Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

b. Why were these values considered important?

Answered: 1 week ago