Find the name of those cities with temperature and condition whose condition is

Question

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

Options:

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

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

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

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

Answer: Option C

Submit Your Solution Below and Earn Points !

Next Question

More Questions on This Topic :

Question 1. Find all the tuples having temperature greater than 'Paris'.....

Question 2. Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79....

Question 3. Find the names of the countries whose condition is sunny.....

Question 4. Find the name of all cities with their temperature, humidity and countries.....

Question 5. Find the name of cities with all entries whose temperature is in the range of 71 and 89....

Question 6. Which of the following query finds the names of the sailors who have reserved at least one boat?....

Question 7. Which of the following query finds colors of boats reserved by "Dustin"?....

Question 8. What does the following query find? (SELECT DISTINCT r.sid FROM boats b, reserves r WHERE b.bid = r.bid AND b.color = 'r....boats b, reserves r WHERE b.bid = r.bid AND b.color = 'green')

Question 9. Which of the following query finds the name of the sailors who have reserved at least two boats?....

Question 10. Which of the following query finds the total rating of the sailors who have reserved boat "103"?....

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI

Tabulation - Test Paper 2 Data Interpretation Reasoning & DI

Test Paper 1 Direction Sense Test Reasoning & DI

ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0

GFM Combined 1 Free Revision Test SAIL JO E-0