Kepler Group interview question

SQL questions using joins order bys. quite straightforward