Find the names of these cities with temperature and condition whose condition i

Question

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy

Options:

A . SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)

B . SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)

C . SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)

D . SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);

Answer: Option A

Submit Your Solution Below and Earn Points !

Next Question

More Questions on This Topic :

Question 1. SQL query to find the temperature in increasing order of all cities....

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

Question 3. Which SQL statement is used to insert new data in a database?....

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

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

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

Question 7. A database is used to....

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

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

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

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