Question 2: SQL 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:...



Database Systems
please help me answer this question I will give you a good rating Thank you!



Question 2: SQL<br>Please see the following tables. Solve the questions with nested queries and aggregation<br>operators.<br>Tables used in this note:<br>Sailors(sid: integer, sname: string, rating: integer, age: real);<br>Boats(bid: integer, bname: string, color: string);<br>Reserves(sid: integer, bid: integer, day: date).<br>1. Find the average age of sailors for each rating level that has at 1least two sailors.<br>3. Find the names and age of sailors who have reserved only blue boats and present them in an<br>ascending order of age.<br>

Extracted text: Question 2: SQL 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 average age of sailors for each rating level that has at 1least two sailors. 3. Find the names and age of sailors who have reserved only blue boats and present them in an ascending order of age.

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here