Find the names of the countries whose condition is sunny

mhmadesk

Save to bookmark

2022-07-08

484

Medium

Find the names of the countries whose condition is sunny.

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

Database, MCQ Questions, Database MCQ-questions,

mhmadesk

2022-07-08

need an explanation for this answer? contact us directly to get an explanation for this answer

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

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)