Introduction to SQL
Find the names of the countries whose condition is sunny.

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79

SELECT * FROM weather WHERE humidity IN (63 to 79)
SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79
SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)
SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

ANSWER DOWNLOAD EXAMIANS APP