Tredence interview question

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