Question: Q 1 . ( 5 0 pts . ) Consider a database with the following scheme: Captain: captainID, name, experience, rating, age Ship: shipID, class,
Q pts Consider a database with the following scheme:
Captain: captainID, name, experience, rating, age
Ship: shipID, class, model, passengerCapacity, range, flag
Route: routeID, fromCity, toCity, distance
SailTrip: tripID, routeID, shipID, captainID, startDate, endDate, noOfPassangers, income
a pts Write an SQL query to retrieve the following information:
"Find ID class, and model of ships that has never sailed with full capacity full capacity means; number of passengers on board is equal to the ship capacity
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
