Kepler Group Interview Question

SQL questions using joins order bys. quite straightforward