CME Group interview question

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