Booking.com Interview Question

Write a query with a db of 3 tables