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 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