Query $11$

Alter reservations table to add constraint that check$-$in date is before the checkout date.

Query $12$

Retrieve the top $5$ guests who have made the most reservations $$ show their names and the number of reservations they made.

Query $13$

Calculate the total revenue for each hotel location from all reservations and their corresponding payments.

Query $14$

Identify the guests who have identical check$-$in and check$-$out dates within the same reservation.

Query $15$

Finda all the rooms with overlapping reservations during a specific date range, which could indicate double booking or perhaps any scheduling conflicts.

Query $16$

Rank the rooms by the number of times they have been reserved in April $2023.$

Hint: One of the many ways would be to use a window function to assign ranks. You can read online and shoot any questions to me$.$

Query $17$

Find Guests with Reservations in Multiple Locations

Query $18$

List all the room details for rooms that generated the Highest Revenue