SHIP Table SHIPNUM SHIPNAME BUILDER LAUNCHDATE WEIGHT CRUISE Table CRUISENUM STA
ID: 644275 • Letter: S
Question
SHIP Table
SHIPNUM
SHIPNAME
BUILDER
LAUNCHDATE
WEIGHT
CRUISE Table
CRUISENUM
STARTDATE
ENDDATE
DIRECTOR
SHIPNUM
PORT Table
PORTNAME
COUNTRY
NUMDOCKS
MANAGER
VISIT Table
CRUISENUM
PORTNAME
_________
COUNTRY
________
ARRDATE
DEPDATE
PASSENGER Table
PASSENGERNUM
PASSENGERNAME
SOCSECNUM
STATE
COUNTRY
VOYAGE TABLE
PASSENGERNUM
CRUISENUM
_
ROOMNUM
FARE
Please use aggregate functions for the following queries
1.1. Who paid the highest price for a cruise trip? Who paid the lowest?
1.2. For each country, find the average weight of ships that have visited the country.
1.4 List the names of cruise directors who have visited at least two different countries.
1.5 Largest builder by total weight
SHIPNUM
SHIPNAME
BUILDER
LAUNCHDATE
WEIGHT
Explanation / Answer
1. SELECT MAX(FARE) FROM VOYAGE TABLE;
SELECT MIN(FARE) FROM VOYAGE TABLE;
2. SELECT PORT.COUNTRY, AVG(WEIGHT) FROM SHIP;
4. SELECT CRUISE.DIRECTOR, VISIT.COUNTRY WHERE MAX [COUNT(COUNTRY)];
5. SELECT SHIP.BUILDER WHERE MAX[SUM(WEIGHT)];
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.