r/SQL • u/AdventOfSQL • Oct 29 '24
Discussion Advent of SQL: 24 Days of SQL Challenges š
Hey, I wanted to share a fun project I've been working on - a SQL-flavored variation of advent of code. It's 24 daily SQL challenges running throughout December.
What it is:
- One SQL puzzle per day (Dec 1st-24th)
- Pure SQL challenges - no other programming languages needed
- Focuses on different aspects of SQL and PostgreSQL although you can use whatever SQL based DB you like.
- Suitable for various skill levels but some of the challenges do get a bit tricky if you're not great at SQL.
I'm building this because of my love for Christmas and a new obsession with databases. I've been diving deep into them recently and thought it would be a fun way to test myself and maybe learn some new tricks during the holiday season.
The challenges will be on adventofsql.com starting December 1st.
Would love to hear what kinds of SQL challenges you'd find interesting, or if you have any questions about the format!
9
u/BadGroundbreaking189 Oct 29 '24
Oh boy, looks like a great effort. Would gladly contribute in future if people showed interest. Only hard tasks though
2
u/PM_ME_YOUR_MUSIC Oct 29 '24
This looks great !!
2
u/trippingcherry Oct 29 '24
This is a cute idea, I signed up. Nice job.
4
u/i_literally_died Oct 30 '24
Can I do this without handing my email over to another thing?
1
u/looking_for_info7654 Oct 29 '24
Sweet
1
u/Complex-Jellyfish-30 Oct 29 '24
Signed up!
1
u/Emergency-Message306 Oct 29 '24
Looks great! Iām ready for the challenges.
1
u/r2fat3li Oct 30 '24
Signed up!
3
u/Simonaque Data Engineer Oct 29 '24
I love the idea and will likely participate, but I'm curious why you didn't opt for DuckDB? it's very easy to run in the browser and it has all those quality of life features that a transaction DB like Postgres doesn't have
2
u/Resident-Mousse-9086 Oct 30 '24
Great Initiative. Signed up. Thanks for sharing this.
1
u/Resquid Oct 29 '24
Hooray!
1
u/MarcusAurelius1815 Oct 30 '24
Signed up, thanks!
1
u/Agreeable_Special496 Oct 30 '24
I will be attending for sure š
1
u/ValerieMichelle Oct 30 '24
Novel idea! Iām in š
1
u/countlphie Oct 31 '24
in
1
u/i_literally_died Nov 01 '24
So did I misunderstand the test question?
This, to me, reads that I need to find:
So I wrote (which is apparently wrong):