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

Question

Admin · Accepted Answer

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

Admin · Answer

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

Admin · Answer

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

Admin · Answer

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

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