Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQL PLEASE ANSWER ALL 8 PROBLEMS Sailors Reserves SID SNAME RATING AGE 22 Dustin 29 Brutus 31 Lubber SIDI BID DAY 22 101 10-0CT-1998 22
SQL PLEASE ANSWER ALL 8 PROBLEMS
Sailors Reserves SID SNAME RATING AGE 22 Dustin 29 Brutus 31 Lubber SIDI BID DAY 22 101 10-0CT-1998 22 102 10-OCT-1998 22 103 08-AUG-1998 22 104 07-0CT-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 102 24-SEP-2010 71 102 25-SEP-2011 32 101 26-SEP-2012 22 101 01-0CT-2013 58 Rus 64 Horatio 71 Zorba 7 35 Py 7 35 Art 95 Bob 96 Frodo 25 63 25 Boats BID BNAME COLOR 101 Interlake blue 102 Interlake red 103 Clipper 104 Mrine green 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. 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 cach 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 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started