Question: Please help me with this question! I just need the one that wrong 5. With the cruise company tables (Appendix I), write SQL queries for

Please help me with this question! I just need the one that wrong

Please help me with this question! I just need the one that

5. With the cruise company tables (Appendix I), write SQL queries for the following scenarios. (25pts) 5.1 List the passenger number(s) of passenger(s) who have been on two different cruises. SELECT PASSENGER. PASSENGERNUM, COUNT(*) FROM PASSENGER, VOYAGE WHERE PASSENGER. PASSENGERNUM = VOYAGE.PASSENGEPN HAVING COUNT ()>=2 2 5.2 List the names of passengers who paid more than 50 on a voyage that visited Canada. SELECT PASSENGER. PASSENGERNAME FROM PASSENGER WHERE PASSENGER.PASSENGERNUM IN (SELECT VOYAGE. PASSENGERNUM FROM VOYAGE WHERE FARE >50 AND VOYAGE.CRUISENUM= (SELECT NISIT.CRUISENUM FROM VISIT WHERE VISIT. COUNTRY = 'CAngda') )

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!

Determine the moment of inertia I x of the shaded area about the x axis. y -100 mm-100 mm- - 150 mm - 150 mm 75 mm 150 mm

Its management information systems Please follow up all the information whatever is mention. The purpose of the project is to manipulate tables and write SQL queries in order to extract various...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

CAN YOU PLEASE HELP ME SOLVE THE QUESTION REFERENCING THE ANNUAL REPORT OF BILLABOG 2015 AND 2016. THANKS FEDERATION BUSINESS SCHOOL BUACC1508 ACCOUNTING AND FINANCE ASSESSMENT TASK 2: GROUP...

these pictures are the figures that are mentioned in the passage Specialty Imports Specialty Imports is an automobile dealership located on the "auto strip" in North-West Brampton (where several...

1. Based on the tables we used in SQL Exercise Part 3 (i.e., CEOs, Companies, Countries), write SQL queries to answer the following questions. Please include both your SQL query and result...

mysql questions. All questions are linked. Even if the pictures are blurry please help write the commands for the questions at least QUNSTION: Pandai Sdn Bhd is a company that runs a tuition center...

Please help answer 16 and 17 or 18 and 20 if you can. This is all the information I was given below. As per the instructions you cannot use JOIN statements or subqueries. Here are the other questions...

QUESTION: In the place of Kashyap, how should someone respond to this demotion? What otherresponses can be suggested to address the events in the case? Please help me in the question above after...

Populating database with sample data AND 5. and 6. Questions. I want answer for 3 questions that i wrote bold and also I mentioned above. Thank you SHIP Shiple ShipName Weight YearBuilt...

Database Mangagement (SQL) Please help with this. I am out of town due to a family emergency. I need to turn in by Thursday. Thank. Please message me with any questions you have so we can coordinate...

A basic assumption of accounting assumes that the dollar is unrelated to business transactions. a poor measure of economic activities. the common unit of measure for all business transactions....

Identify the sources of law in the United States Assignment Overview: In this writing assignment, you will research specific examples of executive orders (that is, U.S. presidential) orders issued in...

If Teslum has a transfer pricing policy that requires transfer at market price, what would the transfer price be ?

Note: This problem is for the 2018 tax year. Daniel B. Butler and Freida C. Butler, husband and wife, file a joint return. The Butlers live at 625 Oak Street in Corbin, KY 40701. Dan's Social...