Query $15$

Retrieve the bookings when the guest stayed for more nights than the average nights of stay for the room type that the guest booked, and the address of the guest begins with 'Birmingham'.

This question requires use of a Common Table Expression $($CTE$).$

For each booking, report the guest ID$,$ booking ID$,$ and the number of nights of the booking.

Order results by guest ID$.$