Database Quizzes SQL Database

Question:
Find the name of cities with all entries whose temperature is in the range of 71 and 89:

Option A):
SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;
Option B):
SELECT * FROM weather WHERE temperature NOT IN (71 and 89);
Option C):
SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;

Correct Answer is Option A):
SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;