3-8

Sailors Reserves DAY SID SNAME RATING AGE 22 Dustin 29 Brutus 31 Lubber 32 58 Rusty10 35 64 Horatio 71 Zorba 45 22 101 10-OCT-1998 22 102 10-OCT-1998 22 103 08-AUG-1998 22 104 07-OCT-1998 31 102 10-NOV-1998 31 103 06-NOV-1998 31 104 12-NOV-1998 64 101 05-SEP-1998 64 102 08-SEP-1998 95 102 24-SEP-2010 71 102 25-SEP-2011 32 101 26-SEP-2012 22 101 01-OCT-2013 45 35 35 25 63 25 85 Art 96 Frodo Boats BIDBNAME 101 Interlake 102 Interlake 103 Clipper 104 Mrine COLOR blue green 3) Write SQL queries to compute the average rating, the sum of the ratings, and the number of ratings. 4) Find the average age of sailors for each rating level that has at least two sailors. 5) Among sailors who have ratings greater than 6 and more than one sailor in that rating, how many over the age of at least 35 have names beginning with letters in the range H through L 6) Of all the sailors who are in age categories 35 and over and have reserved Interlake, show the age category and find the minimum, average, and maximum ratings for each age category. 7) Show boat names and maximum ratings of any sailors who have reserved those boats 8) For each rating level with at least 2 sailors, find the boat rentals for sailors who have rented red boats and who are aged 40 or more