Tredence Interview Question

SQL queries involving outer joins, subqueries, ranking, aggregate functions and datetime functions.