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 70

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. Which SQL statement is used to insert new data in a database?....

Question 2. What is the correct order of clauses in a SQL statement? ....

Question 3. In sql the spaces at the end of the string are removed by....

Question 4. Which of the following statements is true concerning subqueries?....

Question 5. A database is used to....

Question 6. AND, OR and NOT are examples of....

Question 7. The arranging of data in a logical sequence is called....

Question 8. The SQL SELECT statement is capable of....

Question 9. Embedded SQL is which of the following?....

Question 10. SQL views can be used to hide?....

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