Question

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');

Answer 1

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

Step-by-step 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.