Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70F

mhmadesk

Save to bookmark

2022-07-08

387

Medium

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70F.

SELECT city, temperature, condition FROM weather WHERE condition = \'sunny\' AND condition = \'cloudy\' OR temperature > 70;
SELECT city, temperature, condition FROM weather WHERE condition = \'sunny\' OR condition = \'cloudy\' OR temperature > 70;
SELECT city, temperature, condition FROM weather WHERE condition = \'sunny\' OR condition = \'cloudy\' AND temperature > 70;
SELECT city, temperature, condition FROM weather WHERE condition = \'sunny\' AND condition = \'cloudy\' AND temperature > 70;

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

(c).SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;

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

total answers (1)