Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider a database consisting of the following tables (relations): SAILORS(sid, name, rating, age) BOATS(bid, name, color) RESERVED(sid, bid, day). Write SQL statement for each of
Consider a database consisting of the following tables (relations):
SAILORS(sid, name, rating, age)
BOATS(bid, name, color)
RESERVED(sid, bid, day). Write SQL statement for each of the following queries.
(12) Find the names of sailors with age over 20 who have not reserved a green boat.
(13) Find the names of sailors who have reserved at least five boats.
(14) Calculate the average age of all sailors.
(15) Find the name and the age of the youngest sailor.
(16) Find the names of sailors with the highest rating.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started