Question discussion

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

285030Medium 1 reply 3,254 views

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

ASELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70;
BSELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;
CSELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;
DSELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70;

Correct answer: C

Discussion 1

CCommunity02 Jun 2021

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