Pupilfirst interview question

SQL queries including the joins, aggregate and other functions.