CME Group Interview Question

SQL query debugging, fairly easy if you know joins, aggregate functions etc