Superstore SQL-Advanced Questions .md

SQL-Advanced Questions : (Superstore SQL)

* These questions are based on superstore dataset.

1. Find top 5 customers who have purchsed the most in each category.
2. Find top 5 customers who have purchsed the most in each category (without using window functions)
3. Calculate year wise sales for each category without using pivot.
4. Find top 3 products by sales for each city for the year 2017.