Find the names of these cities with temperature and condition whose condition is neithersunny 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 neithersunny 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