Frage im Vorstellungsgespräch bei The Blackstone Group

SQL question was based on Joining different tables and query optimisation