Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

a. SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');
b. SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');
c. SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');
d. SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');


Sagot :

Answer:

The answer is option A "SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy')"

Explanation:

* SQL is a standard language for storing, controlling, manipulating and recovering information in databases. It represents Structured Query Language

* SQL can execute queries against a database, recover information from a data set, embed records in a database, update records in a database, erase records from a database, make new databases, make new tables in a data set, make put away systems in a data set, make views in a database, set authorizations on tables, techniques, and perspectives.

* The IN operator when used can allow you to specify multiple values in a WHERE clause.

The IN operator is an easy way for multiple OR conditions.