Question: Q 4 : Aggregation ( 4 pt ) : Given the following relational schema ( attribute types are omitted for simplicity ) : Sailor (
Q: Aggregation pt: Given the following relational schema attribute types
are omitted for simplicity:
Sailorsid sname, age, rating
Reservesid bid
Boatbid bname, color
a Find the average age of the sailors Hint: Use 'AVG' keyword
b Find the sid of the sailor and the total number of boats reserved by them
You should return a table has sid count
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
