1

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

Correct Answer: SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70

Make the most of this question

This page focuses on one SQL Server MCQs question from Programming. After checking the answer, return to the topic list to practice more or run a timed set.

SQL Server MCQs MCQ: Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70. | Extra Education