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 1) Find the age of the youngest sailor for each rating level. 2) For each red boat, find the number of reservations for this boat. - 3) Write SQL queries to compute the average rating, the sum of the ratings, and the number of ratings