Question: Question 2 : SQL ( 2 0 ) Please see the following tables. Solve the questions with nested queries and aggregation operators. Tables used in
Question : SQL
Please see the following tables. Solve the questions with nested queries and aggregation
operators.
Tables used in this note:
Sailorssid: integer, sname: string, rating: integer, age: real;
Boatsbid: integer, bname: string, color: string;
Reservessid: integer, bid: integer, day: date
Find the name and the age of the youngest sailor.
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.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
