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 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
Get step-by-step solutions from verified subject matter experts
