This repository contains the solutions for the case studies in 8weeksqlchallenge. The 8 Week SQL Challenge is started by Danny Ma through Data With Danny virtual data apprenticeship program, which consists of 8 different SQL challenges.
Note : Solutions are coded in MS SQL Server(SSMS)
📚 Table of Contents:
Please find the solution links for the case studies below. Simply click on the links to access each solution.
In the SQL challenge, I applied SQL techniques like Common Table Expressions (CTEs), subqueries, different join types (inner, outer, self, left, right, cross), string manipulation functions, window functions (including lag, lead, unbounded preceding, rank, row_number), combinatorial math, date functions, statistical summarization, dataset exploration, preprocessing, optimization, and analysis across various sectors to address business questions.