Find the names of the countries whose condition is sunny.

Question

TuteeHUB · Accepted Answer

SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');

TuteeHUB · Answer

SELECT country FROM location WHERE condition = 'sunny';

TuteeHUB · Answer

SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');

TuteeHUB · Answer

SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny');

1.	Find the names of the countries whose condition is sunny.
A.	SELECT country FROM location WHERE condition = 'sunny';
B.	SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');
C.	SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');
D.	SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny');
Answer» C. SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');

Discussion