WRITE SQL queries to do following from the given cruise database tables:(AND SHOW OUTPUT SCREENSHOT TO CONFIRM
Question:
WRITE SQL queries to do following from the given cruise database tables:(AND SHOW OUTPUT SCREENSHOT TO CONFIRM CORRECTNESS) mysql)
1.List of the cruise directors who have been on ships that weight less than 70,000
2.. List the names of passengers who have been on ships that weight less than 70,000.
3.List the cruise directors who have visited the port(s) managed by port manager named Lopez.
4.. List the names of the countries, which have more than 1 ports.
5.Lost and found office at port New York found a bag. We believe that it belongs to a passenger who visited the port. We would like to ask cruise directors to contact passengers who have visited New York. Please generate all pairs that needs to be informed.
6.Names of directors who have worked on different ships listed.
The Cruise Scenario SQL query: SELECT * FROM SHIP; SHIPNUM 005 008 009 012 020 022 025 028 11111 21664 23007 24288 26964 27045 28532 29191 29890 35218 37894 SQL query: SELECT * FROM CRUISE; BUILDER Sea Joy Master The Spirit of Nashville Ajax Ocean TV Ajax Prince Al Ajax Queen Shirley Master Pacific Blue Ace Ace Ace CRUISENUM STARTDATE SHIPNAME Caracas Halifax Princess Oceania La Plata Maracaibo SQL query: SELECT * FROM PORT; Miami Naples LAUNCHDATE WEIGHT 80000 78000 75000 90000 85000 65000 58000 55000 1999-02-01 00:00:00 2003-01-30 00:00:00 2003-05-15 00:00:00 2004-04-20 00:00:00 1999-10-11 00:00:00 2000-05-01 00:00:00 1998-02-01 00:00:00 2001-08-10 00:00:00 PORTNAME COUNTRY NUMDOCKS MANAGER Venezuela 4 Canada 5 Venezuela 2 Venezuela 3 United States 4 Italy 5 ENDDATE 2003-07-05 00:00:00 2003-09-11 00:00:00 Lee 2002-07-05 00:00:00 2002-07-12 00:00:00 Smith 2002-08-14 00:00:00 2002-08-24 00:00:00 Chen 2003-03-28 00:00:00 2003-04-04 00:00:00 Smith 2003-07-01 00:00:00 2003-07-11 00:00:00 Gomez 2003-07-15 00:00:00 2003-07-22 00:00:00 Adams 2003-08-17 00:00:00 2003-08-24 00:00:00 Adams 2003-12-20 00:00:00 2003-12-27 00:00:00 Jones 2004-01-15 00:00:00 2004-01-22 00:00:00 Levin 2004-05-15 00:00:00 2004-05-29 00:00:00 Williams 2004-10-10 00:00:00 | 2004-10-22 00:00:00 Chen DIRECTOR SHIPNUM Lopez Moore Perez Gonzalez Young Angelo 008 009 005 009 020 012 012 009 020 009 020 The Cruise Scenario SQL query: SELECT * FROM SHIP; SHIPNUM 005 008 009 012 020 022 025 028 11111 21664 23007 24288 26964 27045 28532 29191 29890 35218 37894 SQL query: SELECT * FROM CRUISE; BUILDER Sea Joy Master The Spirit of Nashville Ajax Ocean TV Ajax Prince Al Ajax Queen Shirley Master Pacific Blue Ace Ace Ace CRUISENUM STARTDATE SHIPNAME Caracas Halifax Princess Oceania La Plata Maracaibo SQL query: SELECT * FROM PORT; Miami Naples LAUNCHDATE WEIGHT 80000 78000 75000 90000 85000 65000 58000 55000 1999-02-01 00:00:00 2003-01-30 00:00:00 2003-05-15 00:00:00 2004-04-20 00:00:00 1999-10-11 00:00:00 2000-05-01 00:00:00 1998-02-01 00:00:00 2001-08-10 00:00:00 PORTNAME COUNTRY NUMDOCKS MANAGER Venezuela 4 Canada 5 Venezuela 2 Venezuela 3 United States 4 Italy 5 ENDDATE 2003-07-05 00:00:00 2003-09-11 00:00:00 Lee 2002-07-05 00:00:00 2002-07-12 00:00:00 Smith 2002-08-14 00:00:00 2002-08-24 00:00:00 Chen 2003-03-28 00:00:00 2003-04-04 00:00:00 Smith 2003-07-01 00:00:00 2003-07-11 00:00:00 Gomez 2003-07-15 00:00:00 2003-07-22 00:00:00 Adams 2003-08-17 00:00:00 2003-08-24 00:00:00 Adams 2003-12-20 00:00:00 2003-12-27 00:00:00 Jones 2004-01-15 00:00:00 2004-01-22 00:00:00 Levin 2004-05-15 00:00:00 2004-05-29 00:00:00 Williams 2004-10-10 00:00:00 | 2004-10-22 00:00:00 Chen DIRECTOR SHIPNUM Lopez Moore Perez Gonzalez Young Angelo 008 009 005 009 020 012 012 009 020 009 020 The Cruise Scenario SQL query: SELECT * FROM SHIP; SHIPNUM 005 008 009 012 020 022 025 028 11111 21664 23007 24288 26964 27045 28532 29191 29890 35218 37894 SQL query: SELECT * FROM CRUISE; BUILDER Sea Joy Master The Spirit of Nashville Ajax Ocean TV Ajax Prince Al Ajax Queen Shirley Master Pacific Blue Ace Ace Ace CRUISENUM STARTDATE SHIPNAME Caracas Halifax Princess Oceania La Plata Maracaibo SQL query: SELECT * FROM PORT; Miami Naples LAUNCHDATE WEIGHT 80000 78000 75000 90000 85000 65000 58000 55000 1999-02-01 00:00:00 2003-01-30 00:00:00 2003-05-15 00:00:00 2004-04-20 00:00:00 1999-10-11 00:00:00 2000-05-01 00:00:00 1998-02-01 00:00:00 2001-08-10 00:00:00 PORTNAME COUNTRY NUMDOCKS MANAGER Venezuela 4 Canada 5 Venezuela 2 Venezuela 3 United States 4 Italy 5 ENDDATE 2003-07-05 00:00:00 2003-09-11 00:00:00 Lee 2002-07-05 00:00:00 2002-07-12 00:00:00 Smith 2002-08-14 00:00:00 2002-08-24 00:00:00 Chen 2003-03-28 00:00:00 2003-04-04 00:00:00 Smith 2003-07-01 00:00:00 2003-07-11 00:00:00 Gomez 2003-07-15 00:00:00 2003-07-22 00:00:00 Adams 2003-08-17 00:00:00 2003-08-24 00:00:00 Adams 2003-12-20 00:00:00 2003-12-27 00:00:00 Jones 2004-01-15 00:00:00 2004-01-22 00:00:00 Levin 2004-05-15 00:00:00 2004-05-29 00:00:00 Williams 2004-10-10 00:00:00 | 2004-10-22 00:00:00 Chen DIRECTOR SHIPNUM Lopez Moore Perez Gonzalez Young Angelo 008 009 005 009 020 012 012 009 020 009 020 The Cruise Scenario SQL query: SELECT * FROM SHIP; SHIPNUM 005 008 009 012 020 022 025 028 11111 21664 23007 24288 26964 27045 28532 29191 29890 35218 37894 SQL query: SELECT * FROM CRUISE; BUILDER Sea Joy Master The Spirit of Nashville Ajax Ocean TV Ajax Prince Al Ajax Queen Shirley Master Pacific Blue Ace Ace Ace CRUISENUM STARTDATE SHIPNAME Caracas Halifax Princess Oceania La Plata Maracaibo SQL query: SELECT * FROM PORT; Miami Naples LAUNCHDATE WEIGHT 80000 78000 75000 90000 85000 65000 58000 55000 1999-02-01 00:00:00 2003-01-30 00:00:00 2003-05-15 00:00:00 2004-04-20 00:00:00 1999-10-11 00:00:00 2000-05-01 00:00:00 1998-02-01 00:00:00 2001-08-10 00:00:00 PORTNAME COUNTRY NUMDOCKS MANAGER Venezuela 4 Canada 5 Venezuela 2 Venezuela 3 United States 4 Italy 5 ENDDATE 2003-07-05 00:00:00 2003-09-11 00:00:00 Lee 2002-07-05 00:00:00 2002-07-12 00:00:00 Smith 2002-08-14 00:00:00 2002-08-24 00:00:00 Chen 2003-03-28 00:00:00 2003-04-04 00:00:00 Smith 2003-07-01 00:00:00 2003-07-11 00:00:00 Gomez 2003-07-15 00:00:00 2003-07-22 00:00:00 Adams 2003-08-17 00:00:00 2003-08-24 00:00:00 Adams 2003-12-20 00:00:00 2003-12-27 00:00:00 Jones 2004-01-15 00:00:00 2004-01-22 00:00:00 Levin 2004-05-15 00:00:00 2004-05-29 00:00:00 Williams 2004-10-10 00:00:00 | 2004-10-22 00:00:00 Chen DIRECTOR SHIPNUM Lopez Moore Perez Gonzalez Young Angelo 008 009 005 009 020 012 012 009 020 009 020
Expert Answer:
Im sorry but Im not able to provide screenshots to confirm the correctness of SQL queries However I can certainly help you write the SQL queries based ... View the full answer
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Students also viewed these databases questions
-
The following graph is the graph of a sine function. Identify the following characteristics based on this graph. 4 3 2 -3-25-2-15--05 0 0.5% 1.5 2 25 3 Amplitude: Phase Shift: Period: Equation of the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
A company conducts a Security model workshop to review configuration options. The company uses Microsoft Entra ID to control access and permissions within multiple corporate applications. When users...
-
Consider the failed attempt of Alice to get Bob's public key in Fig. 8-23. Suppose that Bob and Alice already share a secret key, but Alice still wants Bob's public key. Is there now a way to get it...
-
The distribution constant for X between n-hexane and water is 8.9. Calculate the concentration of X remaining in the aqueous phase after 50.0 mL of 0.200 M X is treated by extraction with the...
-
A survey of German adults found that 73% of customers who shop online pay through PayPal. You randomly select 150 German adults who shop online. Find the probability that the number who pay through...
-
Several years ago, River City built a water purification plant to remove toxins and filter the citys drinking water. Because of population growth, the demand for water next year will be more than the...
-
After all of the account balances have been extended to the Balance Sheet columns of the work sheet, the totals of the Debit and Credit columns are $28,246 and $21,306, respectively. What is the...
-
What characterizes someone who views shopping as a form of entertainment (Tables 1B through 7B)? Which factors contribute most? How do your findings relate to the information presented in Consumer...
-
A Norman window has the shape of a rectangle capped with a semicircle, as shown below a If the window is 16 inches wide, and the rectangular portion of the window is 18 inches tall, find the area of...
-
The ratio of boys to girls in Ms. Zombo's class is 5 to 2. In Mr. Stolarski's class it is 5 to 4. If there are 35 students in Ms. Zombo's class and 27 students in Mr. Stolarski's class, what is the...
-
Anand runs an airport coffee shop. He sells yogurt for $10 and granola for $3. Customers are only interested in buying one yogurt, one granola, or both. In a typical hour, hell have one person buying...
-
4. The Pioneer Corporation currently paid a $2.50 per share dividend on its common stock. Dividends are expected to grow forever at 3%, and investors require a 10% rate of return. Pioneer's...
-
How would I solve this step by step. There are other questions on Chegg, but none of them explain how they got their answers. I want to know mathematically and and what equations to use to find the...
-
Peer Post: During the recession, the Real gross domestic product (GDP) fell 4.3 percent from its peak in 2007 to 2009, the largest decline in the postwar era (based on data as of October 2013)....
-
Assume that two securities, A and B, constitute the market portfolio, their proportions and variances are 0.39, 160, and 0.61, 340, respectively. The covariance of the two securities is 190. Estimate...
-
Differentiate. y = ln(3x + 1) ln(5x + 1)
-
Write SQL queries to answer the following questions: a. How many students were enrolled in section 2714 during semester 1-2015? b. How many students were enrolled in ISM 3113 during semester 1-2015?
-
What types of data pollution/cleansing problems might occur with the Fitchwood OLTP system data?
-
A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account: CHECKING: Acct No, Date Opened, Balance, Service Charge SAVINGS: Acct No, Date...
-
The materials which exhibit the same elastic properties in all directions are known as: (a) Homogeneous (b) Isotropic (c) Isentropic (d) Inelastic
-
In a reaction steam turbine, steam expands: (a) In nozzle only (b) In moving blades only (c) Partly in nozzle partly in blades (d) None of the above
-
In impulse turbines, pressure on the two sides of the moving blades: (a) Increases (b) Decreases (c) Remains same (d) None of the above
Study smarter with the SolutionInn App