Skip to content

Latest commit

 

History

History
9 lines (7 loc) · 546 Bytes

SQL-Intermediate Questions.md

File metadata and controls

9 lines (7 loc) · 546 Bytes
Raw

SQL-Intermediate Questions : (Superstore SQL)

* These questions are based on superstore dataset.

  1. Calculate profit for each state and sub_category for year 2016.
  2. Find 5 sub_categories which have performed low in 2017.
  3. Find 5 states which needs marketing.
  4. XYZ company wants to launch a new phone. They want to know from us which 2 states are good to go for offline launch.
  5. Marketing Manager of Furniture category wants to start a discount coupon. Find out which states need this type of strategy.