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

mhmadesk

Save to bookmark

2022-07-08

496

Medium

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

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

Database, MCQ Questions, Database MCQ-questions,

mhmadesk

2022-07-08

need an explanation for this answer? contact us directly to get an explanation for this answer

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

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)