Question: Use SQL Assistant and the database db fdms hcl to write SQL queries for the following Port 1. List passengers that have taken more than

 Use SQL Assistant and the database db fdms hcl to write

Use SQL Assistant and the database db fdms hcl to write SQL queries for the following Port 1. List passengers that have taken more than 2 cruises. PASS 11797 PASSENGERNAME Count (CRUISENUN) Brown 2. List ships from the same builder such that the ship weight differs more than 10000 firs firstweigh ince Al Ocean TV 75000 ince Al Th e Spirit of shville 3. List passenger number and name for passengers who have taken cruisenum 27045 and 11111 (both cruises, not just one). Sort by passenger name 11797 12345 Brown Douglas 4. List passenger number and name of passengers who have take a cruise on ship 'Prince Al". Sort by passenger name 3479 11797 12345 Bean Brown Douglas

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 Databases Questions!