EXL Service Interview Question

SQL question - Join, aggregate functions