Using the tables provided above, provide SQL statements for the following queries…. 1 answer below »

Using the tables provided above, provide SQL statements for the following queries.

a. Display the name of the client who has made the most reservations with Getaway Holidays.

b. Display the name of the client who has booked the reservation for the longest period.

c. Display the Room no, Room type, Room rate and No of guests for the reservation made by

client(s) having last name “Perez”.

d. Display the name of the outdoor instructor who has the most duties as an activity supervisor.

e. Display the reservations (reservation number and duration) whose duration is greater than the

average duration of reservations.

Attachments:

2020-Semester….pdf

GHRSchema.sql….docx

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

The post Using the tables provided above, provide SQL statements for the following queries…. 1 answer below » appeared first on Affordable Nursing Writers.