Pregunta de entrevista de Kepler Group

SQL questions using joins order bys. quite straightforward