Question: Question 2 : SQL ( 2 0 ) Please see the following tables. Solve the questions with nested queries and aggregation operators. Tables used in

Question 2: SQL (20)
Please see the following tables. Solve the questions with nested queries and aggregation
operators.
Tables used in this note:
Sailors(sid: integer, sname: string, rating: integer, age: real);
Boats(bid: integer, bname: string, color: string);
Reserves(sid: integer, bid: integer, day: date).
1.Find the name and the age of the youngest sailor.
2.Find the names and age of sailors who have reserved only blue boats and present them in an
ascending order of age.
Fina the colors of boats that have been reserved more than the average number of
reservations across all the boats.
Question 2 : SQL ( 2 0 ) Please see the following

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!