Citi interview question

Questions on OOP and SQL Joins and Aggregations