Booking Holdings interview question

The interviewer asked me sql query on joins