SAILORS COMPLETE WORK

 1.Find the names and ages of all sailors.

2.Find all sailors with a rating above 7.

3.Find the names of sailors who have reserved boat number 103
4.Find the sids of sailors who have reserved a red boat.
5.Find the names of sailors who have reserved a red boat.
6.Find the colors of boats reserved by Lubber.
7.Find the names of sailors who have reserved atleast one boat.
8.Compute increments for the ratings of persons who have sailed two different boats on the same day.
9.Find the ages of sailors whose name begins and ends with B and has at least three characters.
10.Find the names of sailors who have reserved a red or a green boat.
11.Find the names of sailors who have reserved aboth a red and a green boat.
12.Find the sids of all sailors who have reserved red boats but not green boats.
13.Find all sids of sailors who have rating of 10 or have reserved boat 104
14.Find the names of sailors who have not reserved a red boat.
15.Find sailors whose rating is better than some sailor called Horatio.
16.Find sailors whose rating is better than every sailor called Horatio.
17.Find the sailors with the highest rating.
18.Find the names of sailors who have reserved aboth a red and a green boat.
19.Find the names of sailors who have reserved all boats.
20.Find the average age of all sailors.
21.Find the average of sailors with a rating of 10.
22.Find the name and age of oldest sailor.
23.Count the number of sailors.
24.Count the number of different sailor names.
25.Find the names of sailors who are older than the oldest sailor with a rating of 10.
26.Find the age of the youngest sailor for each rating level.
27.Find the age of the youngest sailor who is eligible to vote (i.e., is atleast 18 years old) for each rating level with atleast two such sailors.
28.For each red boat, find the number of reservations for this boat.
29. Find the average age of sailors for each rating level that has atleast two sailors.
30.Find the average age of sailors who are of voting age (i.e., is atleast 18 years old) for each rating level that has atleast two sailors.
31.Find the average age of sailors who are of voting age (i.e., is atleast 18 years old) for each rating level that has atleast two such sailors.
32. Find those ratings for which the average age of sailors is the minimum over all ratings.