?
Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy
Answer & Solution
Correct Answer:
Option
A
To retrieve the names of cities with their respective temperature and condition where the condition is neither "sunny" nor "cloudy," you should use the SQL query SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy'); (Option A). This query selects the desired columns from the "weather" table and filters the rows where the "condition" is not "sunny" or "cloudy." This way, you'll get the information for cities with conditions other than "sunny" or "cloudy."
Join the Discussion
Login to post a comment or share your explanation.
Login