This Repository contains the solution for the all case studies in #8WeeksSqlChallenge created by Danny Ma [https://www.linkedin.com/in/datawithdanny/?originalSubdomain=au]

I used Microsoft SQL Server in writing SQL queries to solve these case studie

1. https://8weeksqlchallenge.com/case-study-1/
2. https://8weeksqlchallenge.com/case-study-2/
3. https://8weeksqlchallenge.com/case-study-3/
4. https://8weeksqlchallenge.com/case-study-4/
5. https://8weeksqlchallenge.com/case-study-5/
6. https://8weeksqlchallenge.com/case-study-6/
7. https://8weeksqlchallenge.com/case-study-7/
8. https://8weeksqlchallenge.com/case-study-8/

• Data cleaning & transformation
• Aggregations
• Joins
• CTEs
• Variables
• Window functions
  • Ranking (ROW_NUMBER, DENSE_RANK)
  • Analytics (LEAD, LAG)
• CASE WHEN statements
• Subqueries
• UNION & INTERSECT
• DATETIME functions
• Data type conversion
• TEXT functions, text and string manipulation