mySQL

Reserves Sailors SID SNAME RATING AGE 22 Dustin 7 45 29 Brutus 33 Lubber 55 32 Andy 45 58 Rusty 64 Horatio 71 Zorba 10 74 Happy 85 Art 25 Bob 63 96 Frodo 325 10 7 35 35 SID BID 22 101 22 102 103 104 102 103 104 64 101 64 102 102 71 102 101 22101 DAY 10-OCT-1998 10-OCT-1998 08-AUG-1998 07-OCT-1998 10-NOV-1998 06-NOV-1998 12-NOV-1998 05-SEP-1998 08-SEP-1998 24-SEP-2010 25-SEP-2011 26-SEP-2012 01-OCT-2013 55 7 35 3 95 95 32 Boats BID BNAME 101 Interlake 102 Interlake 103 Clipper 104 Mrine COLOR blue red red 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. are in 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 mom3s