?
Find the names of the countries whose condition is sunny.
Answer & Solution
Correct Answer:
Option
B
To find the names of countries where the condition is "sunny," you should use the SQL query SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = 'sunny'); (Option B). This query correctly uses a subquery to first select the cities with a "sunny" condition from the "weather" table and then matches those cities to the "city" column in the "location" table to determine the corresponding countries. Option B is the appropriate choice for obtaining the desired result.
Join the Discussion
Login to post a comment or share your explanation.
Loginor on the other way aroud i think this is an ambiguous query.