Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sailors Reserves DAY SID SNAME RATING AGE 22 Dustin 29 Brutus 31 Lubber 32 58 Rusty10 35 64 Horatio 71 Zorba 45 22 101 10-OCT-1998

image text in transcribed
image text in transcribed
Sailors Reserves DAY SID SNAME RATING AGE 22 Dustin 29 Brutus 31 Lubber 32 58 Rusty10 35 64 Horatio 71 Zorba 45 22 101 10-OCT-1998 22 102 10-OCT-1998 22 103 08-AUG-1998 22 104 07-OCT-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 95 102 24-SEP-2010 71 102 25-SEP-2011 32 101 26-SEP-2012 22 101 01-OCT-2013 45 35 35 25 63 25 85 Art 96 Frodo Boats BIDBNAME 101 Interlake 102 Interlake 103 Clipper 104 Mrine COLOR blue 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 h through L. ave names beginning with letters in the range H 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. 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

Step: 3

blur-text-image

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

Sybase Database Administrators Handbook

Authors: Brian Hitchcock

1st Edition

0133574776, 978-0133574777

More Books

Students also viewed these Databases questions

Question

Write down the Limitation of Beer - Lamberts law?

Answered: 1 week ago

Question

Discuss the Hawthorne experiments in detail

Answered: 1 week ago

Question

Explain the characteristics of a good system of control

Answered: 1 week ago

Question

State the importance of control

Answered: 1 week ago

Question

Define procedural justice. How does that relate to unions?

Answered: 1 week ago