Pregunta de entrevista de Accenture

Sql query from two table using joins