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
Answer:A
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
Explanation: The BETWEEN operator is used to select values within a range.