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

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

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

39.
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')

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

Read More Section(Sql Miscellaneous)

Each Section contains maximum 70 questions. To get more questions visit other sections.