Question
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');
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy
Similar Questions
Discover Related MCQs
Q. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70F.
View solution
Q. Find all the tuples having temperature greater than 'Paris'.
View solution
Q. Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79
View solution
Q. Find the names of the countries whose condition is sunny.
View solution
Q. Find the name of all cities with their temperature, humidity and countries.
View solution
Q. Find the name of cities with all entries whose temperature is in the range of 71 and 89
View solution
Q. Which of the following query finds the names of the sailors who have reserved at least one boat?
View solution
Q. Which of the following query finds colors of boats reserved by "Dustin"?
View solution
Q. What does the following query find?
(SELECT DISTINCT r.sid
FROM boats b, reserves r
WHERE b.bid = r.bid
AND b.color = 'red')
MINUS
(SELECT DISTINCT r.sid
FROM boats b, reserves r
WHERE b.bid = r.bid
AND b.color = 'green')
View solution
Q. Which of the following query finds the name of the sailors who have reserved at least two boats?
View solution
Q. Which of the following query finds the total rating of the sailors who have reserved boat "103"?
View solution
Q. The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs
View solution
Q. If a query involves NOT, AND, OR with no parenthesis
View solution
Q. Let the statement
SELECT column1 FROM myTable;
return 10 rows. The statement
SELECT ALL column1 FROM myTable;
will return
View solution
Q. Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement
SELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);
prints
View solution
Q. Which of the following SQL commands can be used to add data to a database table?
View solution
Q. Which of the following join is also called as an 'inner-join'?
View solution
Q. The result of a SQL SELECT statement is a ________ .
View solution
Q. Which of the following query is correct for using comparison operators in SQL?
View solution
Q. How to select all data from student table starting the name from letter 'r'?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
