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

• A. SELECT * FROM weather WHERE humidity IN (63 to 79)
• B. SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)
• C. SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
• D. SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

Correct Answer: C