Q. Find all the cities with temperature, condition and humidity whose humidity is in the rangeof 63 to 79. (Solved)
1. SELECT * FROM weather WHERE humidity IN (63 to 79)
2. SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)
3. SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
4. SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79
- c. SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79