Q1. (30 pts.) Recall from somewhere? Consider this as a second chance and do your best...

Transcribed Image Text:

Q1. (30 pts.) Recall from somewhere? Consider this as a second chance and do your best to benefit from this favor. 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. (10 pts.) Write an SQL query to retrieve the following information: "Find name, experience, and ratings of captains who had sailed from zmir to Southampton, and from Southampton to New York at least once." Q1. (30 pts.) Recall from somewhere? Consider this as a second chance and do your best to benefit from this favor. 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. (10 pts.) Write an SQL query to retrieve the following information: "Find name, experience, and ratings of captains who had sailed from zmir to Southampton, and from Southampton to New York at least once."

Answer rating: 100% (QA)

To retrieve the specified information with an SQL query we need to join the tables in the database s... View the full answer