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;

C. SELECT humidity = 89 FROM weather;

D. SELECT city FROM weather;

Answer: Option B

Solution(By Examveda Team)

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.