EXL Service interview question

SQL question - Join, aggregate functions