Pregunta de entrevista de Infosys

one SQL query which involved joins