Pergunta de entrevista da empresa Booking Holdings

The interviewer asked me sql query on joins