Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SHIP Shop ShipName Weight Yearuilt PassengerCapacity CRUISE Cruise erialNo Sailing Date ReturnDate Stip.Q Booking Cruise SerialNo Passenger Price Satisfactionate Passenger Passenperio PFirstName PlastName PStreetAddress PCity

image text in transcribed
image text in transcribed
SHIP Shop ShipName Weight Yearuilt PassengerCapacity CRUISE Cruise erialNo Sailing Date ReturnDate Stip.Q Booking Cruise SerialNo Passenger Price Satisfactionate Passenger Passenperio PFirstName PlastName PStreetAddress PCity PState PPostalCode PCountry VISIT Cruise SerialNo PortiD VisitOrder PORT Portle PortName PortCountry DockingFee World Traveler Cruise Line SHE Ship Number Ship None We Year Built Passenger Capacity CRUISE Que Number Sailing Date Retum Date VISITS Vis Order PORT BOOKING Satisfaction Country Docking Fee PASSENGER Name First Nam, Middle Name Last Name Address Street Address, City State, Postal Code County Share DOU Q Search in Document Home Insert Design Layout >> A. A Paste Font Paragraph Styles 8. Which cruises have Istanbul as the departure port (Hint: the visit order should be equal to 1) 9. Which passengers have visited Venice in October 2015? (Hint: you may use the Month and Year functions on SailingDate and see if SailingDate was in October 2015.) CAN YOU PLEASE ANSWER 5 QUESTIONS 8-9-10-11-12 I APPRECIATE YOUR WORK 10. What is the duration of each cruise (Hint: Use the DATEDIFF function to determine the duration) 11. What is the number of bookings on each cruise? Display cruiseld and number of bookings. What is the average rating of all the cruises? 13. What is the average rating for cruise with 12. Page 2 of 2 - 103%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Reliability Engineering Designing And Operating Resilient Database Systems

Authors: Laine Campbell, Charity Majors

1st Edition

978-1491925942

More Books

Students also viewed these Databases questions

Question

=+Where does the focus of labor relations lie? Is it collective

Answered: 1 week ago

Question

=+With whom does the firm have to negotiate?

Answered: 1 week ago