ActionIQ Interview Question

1. SQL Joins 2. Reverse a list in Python 3. Remove duplicates from the list in python 4. SQL query which required joining 3 tables along with use of windows functions such as Rank() and aggregations with having clause