Answered

At Westonci.ca, we make it easy to get the answers you need from a community of informed and experienced contributors. Connect with a community of experts ready to help you find accurate solutions to your questions quickly and efficiently. Discover detailed answers to your questions from a wide network of experts on our comprehensive Q&A platform.

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.

We hope our answers were helpful. Return anytime for more information and answers to any other questions you may have. We appreciate your time. Please come back anytime for the latest information and answers to your questions. Westonci.ca is committed to providing accurate answers. Come back soon for more trustworthy information.