Using the tables provided above, provide SQL statements for the following queries....
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.