EXL Service interview question

Simple SQL queries for join and some calculations