Skip to content

Latest commit

 

History

History
14 lines (12 loc) · 602 Bytes

SQL-Basic Questions.md

File metadata and controls

14 lines (12 loc) · 602 Bytes

SQL-Basic Questions :

* These questions are based on superstore dataset.

  1. How many cities are there in city table?
  2. How many unique cities are there?
  3. Find duplicate cities name ?
  4. Find the number of orders in each year?
  5. Find the monthly sales of year 2017?
  6. Find top 2 months in which we have high sales in year 2016?
  7. Find top 2 months in which we have low sales in year 2017?
  8. Extract country code from id of orders table
  9. Extract catgeory from product_id
  10. Count how many product we have sold in total for each category. *You only need to use orders table.