## 31. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70^{o}F.

^{o}F.

## 32. Find all the tuples having temperature greater than 'Paris'.

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

## 34. Find the names of the countries whose condition is sunny.

## 35. Find the name of all cities with their temperature, humidity and countries.

## 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')

(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')