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

Question

Admin · Accepted Answer

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

Admin · Answer

SELECT city, temperature, condition FROM weather WHERE condition = &lsquo;sunny&rsquo; AND condition = &lsquo;cloudy&rsquo; AND temperature > 70

Admin · Answer

SELECT city, temperature, condition FROM weather WHERE condition = &lsquo;sunny&rsquo; OR condition = &lsquo;cloudy&rsquo; OR temperature > 70

Admin · Answer

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

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