Write SQL queries, use at least one view for each query. Then, evaluate the queries on the
Question:
Write SQL queries, use at least one view for each query. Then, evaluate the queries on the cruise tables (and views) in MySQL database, and copy the answers here.
List the directors who have worked on ships built by Ajax. use the view CruiseInfo created above in the previous question.
List the countries that have been visited by at least one Big Ship (as defined in 1.1 called table BigShips).
Create ANOTHER new table named frequent travelers (FreqTrav). It will only store passengers who have taken more than 2 trips with the company. It will record the passenger name, passenger number, address, phone number, total number of trips, and total fare paid. Show your CREATE TABLE query and INSERT query. Please insert the records using subquery (i.e. insert from a SELECT query)
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last