Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy

Question

TuteeHUB · Accepted Answer

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

TuteeHUB · Answer

SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');

TuteeHUB · Answer

SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');

TuteeHUB · Answer

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');

1.	Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy
A.	SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');
B.	SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');
C.	SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');
D.	SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');
Answer» B. SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

Discussion