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

Question

TuteeHUB · Accepted Answer

NA

TuteeHUB · Answer

SELECT * FROM weather WHERE temperature NOT IN (71 to 89);

TuteeHUB · Answer

SELECT * FROM weather WHERE temperature NOT IN (71 and 89);

TuteeHUB · Answer

SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;

TuteeHUB · Answer

SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;

1.	Find the name of cities with all entries whose temperature is in the range of 71 and 89
A.	SELECT * FROM weather WHERE temperature NOT IN (71 to 89);
B.	SELECT * FROM weather WHERE temperature NOT IN (71 and 89);
C.	SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;
D.	SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;
Answer» E.

Discussion