This repository contains my solutions for the Advent of SQL challenges. Each folder includes the challenge question as a separate file, create and insert statements as another file and the solution with in-line comments explaining the approach used to solve it.
Each folder represents a day's challenge:
-
day01/
create_and_populate.sql
- Contains Create and Insert statements.question.txt
- Contains the challenge description.solution.sql
- Contains the challenge solution with in-line explanations as comments.
-
day02/
create_and_populate.sql
question.txt
solution.sql
...
Advent of SQL is a 24-day series of SQL challenges with a Christmas theme. From December 1st to December 24th, a new challenge is provided daily. Each challenge includes a database dump to work with and is designed to enhance SQL skills.
Feel free to explore, learn, or suggest improvements.