Cvent interview question

SQL queries relating to aggregate functions and joins.