Question
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 to Expert-Tailored 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
Professional Microsoft SQL Server 2012 Administration
Authors: Adam Jorgensen, Steven Wort
1st Edition
1118106881, 9781118106884
