Domanda di colloquio di Carousell

SQL question to write query with joins