Question d’entretien chez Infosys

SQL question regarding joins and nested query