Introduction to SQL
Find the name of cities with all entries whose temperature is in the range of 71 and 89

SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;
SELECT * FROM weather WHERE temperature NOT IN (71 and 89);
SELECT * FROM weather WHERE temperature NOT IN (71 to 89);
SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;

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 NOT BETWEEN 63 AND 79
SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)
SELECT * FROM weather WHERE humidity IN (63 to 79)
SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

ANSWER DOWNLOAD EXAMIANS APP