Question: Write SQL SELECT commands to answer the following queries.... Find the start and end dates of cruise number 3 5 2 1 8 . List

Write SQL SELECT commands to answer the following queries....
Find the start and end dates of cruise number 35218.
List the names and ship numbers of the ships built by the Ace Shipbuilding Corporation that weigh more than 60,000 tons.
List the companies that have built ships for Happy Cruise Lines
Find the total number of docks in all the ports in Canda
Find the average weight of the ships built by the Ace Shipbuilding Corporation that have been launched since 2000.
How many ports in Venezuela have at least 3 docks
Find the total number of docks in each country. List the results in order from most to least
Find the total number of ports in each country
Find the total number of docks in each country but include only those counties that have at least twelve docks in your answer.
Find that name of the ship that operated in (was used on) cruise number 35218.
List the names, states and countries of the passengers who sailed on The Spirit of Nashville on cruises that began during July 2011.
Find the names of the company's heaviest ships.
Find the names of the companys heaviest ships that began a cruise between July 15,2011 and July 31,2011.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!