Q27
Find all the cities whose humidity is 89, Table Name weather
A.
SELECT city WHERE humidity = 89;
B.
SELECT city FROM weather WHERE humidity = 89;
AnswerC.
SELECT humidity = 89 FROM weather;
D.
SELECT city FROM weather;
Answer: Option B
Solution
Answer: Option B
Solution:
To retrieve all the cities whose humidity is 89 from the "weather" table, you should use the SELECT city FROM weather WHERE humidity = 89; query. Option B is the correct choice because it specifically selects the "city" column from the "weather" table where the "humidity" is equal to 89. This query will return the desired result, listing the cities meeting the specified humidity condition.