# SQL challenges

Story-driven SQL puzzles you solve with DuckDB. https://dbquacks.com/challenges

## WEEKLY QUACK CHALLENGE!

ONE FRESH SQL PUZZLE EVERY WEEK. SOLVE IT IN AS FEW GUESSES AS YOU CAN!

All 15 challenges in one file: https://dbquacks.com/challenges/weekly.md

- [THE BAKER'S DOZEN](https://dbquacks.com/challenges/weekly/1.md) — medium
- [QUACKSTARTER](https://dbquacks.com/challenges/weekly/2.md) — medium
- [DUCK OLYMPICS PHOTO FINISH](https://dbquacks.com/challenges/weekly/3.md) — hard
- [MIGRATION LAYOVERS](https://dbquacks.com/challenges/weekly/4.md) — hard
- [THE FROG INVASION](https://dbquacks.com/challenges/weekly/5.md) — hard
- [DUCK ELECTION NIGHT](https://dbquacks.com/challenges/weekly/6.md) — medium
- [THE POND-WIDE BLACKOUT](https://dbquacks.com/challenges/weekly/7.md) — hard
- [NIGHT AT THE DUCKSEUM](https://dbquacks.com/challenges/weekly/8.md) — hard
- [THE LILY PAD EXCHANGE](https://dbquacks.com/challenges/weekly/9.md) — medium
- [PONDIFY WRAPPED](https://dbquacks.com/challenges/weekly/10.md) — hard
- [QUACKBER SURGE](https://dbquacks.com/challenges/weekly/11.md) — medium
- [STANDING ROOM ONLY](https://dbquacks.com/challenges/weekly/12.md) — hard
- [THE RUMOR MILL](https://dbquacks.com/challenges/weekly/13.md) — hard
- [THE MIDNIGHT BUFFET](https://dbquacks.com/challenges/weekly/14.md) — medium
- [THE DOUBLE DIP](https://dbquacks.com/challenges/weekly/15.md) — medium

## THE CHRISTMAS HEIST!

CHRISTMAS PRESENTS HAVE VANISHED! HELP DUCKBERT UNCOVER THE TRUTH IN THIS HOLIDAY MYSTERY!

All 15 challenges in one file: https://dbquacks.com/challenges/christmas.md

- [The Missing Presents Report](https://dbquacks.com/challenges/christmas/1.md) — easy
- [The Suspect Pool](https://dbquacks.com/challenges/christmas/2.md) — easy
- [The Pattern Emerges](https://dbquacks.com/challenges/christmas/3.md) — easy
- [The GPS Surveillance Net](https://dbquacks.com/challenges/christmas/4.md) — medium
- [Searching the Evidence Logs](https://dbquacks.com/challenges/christmas/5.md) — medium
- [The Security System Deep Dive](https://dbquacks.com/challenges/christmas/6.md) — hard
- [The Weighted Evidence](https://dbquacks.com/challenges/christmas/7.md) — medium
- [Weather Forensics at Scale](https://dbquacks.com/challenges/christmas/8.md) — hard
- [The Elite Performers](https://dbquacks.com/challenges/christmas/9.md) — medium
- [Multi-Checkpoint Access Patterns](https://dbquacks.com/challenges/christmas/10.md) — hard
- [Package Chain of Custody](https://dbquacks.com/challenges/christmas/11.md) — hard
- [GPS Breadcrumb Trail Analysis](https://dbquacks.com/challenges/christmas/12.md) — hard
- [The Secret Route](https://dbquacks.com/challenges/christmas/13.md) — hard
- [Telemetry Data Mining at Scale](https://dbquacks.com/challenges/christmas/14.md) — hard
- [The Christmas Miracle Revealed](https://dbquacks.com/challenges/christmas/15.md) — hard

## THE GREAT DUCK MIGRATION!

PUT YOUR SQL PROWESS TO THE TEST IN A THRILLING DATA-DRIVEN ADVENTURE GAME!

All 42 challenges in one file: https://dbquacks.com/challenges/athletic.md

- [The Great Migration Scout](https://dbquacks.com/challenges/athletic/1.md) — easy
- [Migration Team Assembly](https://dbquacks.com/challenges/athletic/2.md) — easy
- [Formation Flying Prep](https://dbquacks.com/challenges/athletic/3.md) — medium
- [Veteran Navigator Search](https://dbquacks.com/challenges/athletic/4.md) — medium
- [Migration Leader Selection](https://dbquacks.com/challenges/athletic/5.md) — hard
- [Hall of Champions](https://dbquacks.com/challenges/athletic/6.md) — hard
- [The Rising Star](https://dbquacks.com/challenges/athletic/7.md) — hard
- [Hometown Pride Count](https://dbquacks.com/challenges/athletic/8.md) — easy
- [Speed Champions Registry](https://dbquacks.com/challenges/athletic/9.md) — easy
- [Consistent Excellence Search](https://dbquacks.com/challenges/athletic/10.md) — medium
- [Cross-Training Champions](https://dbquacks.com/challenges/athletic/11.md) — medium
- [Versatile Victory Formation](https://dbquacks.com/challenges/athletic/12.md) — hard
- [Recovery Watch Protocol](https://dbquacks.com/challenges/athletic/13.md) — hard
- [Age Division Protocol](https://dbquacks.com/challenges/athletic/14.md) — medium
- [Backup Roster Assembly](https://dbquacks.com/challenges/athletic/15.md) — easy
- [Training Progress Review](https://dbquacks.com/challenges/athletic/16.md) — medium
- [Forward Momentum Scout](https://dbquacks.com/challenges/athletic/17.md) — hard
- [Elite Tier Ranking](https://dbquacks.com/challenges/athletic/18.md) — hard
- [Elite Squadron Assembly](https://dbquacks.com/challenges/athletic/19.md) — hard
- [The Perfect Score Archive](https://dbquacks.com/challenges/athletic/20.md) — easy
- [The Iron Will Award](https://dbquacks.com/challenges/athletic/21.md) — easy
- [Regional Excellence Analysis](https://dbquacks.com/challenges/athletic/22.md) — medium
- [Weekend Warriors](https://dbquacks.com/challenges/athletic/23.md) — medium
- [Deputy Formation Leaders](https://dbquacks.com/challenges/athletic/24.md) — hard
- [The Incomplete Roster](https://dbquacks.com/challenges/athletic/25.md) — hard
- [Performance Quartile Assignment](https://dbquacks.com/challenges/athletic/26.md) — hard
- [Name Analysis for Roster Organization](https://dbquacks.com/challenges/athletic/27.md) — easy
- [Peak Performance Season](https://dbquacks.com/challenges/athletic/28.md) — medium
- [Water Specialists Identification](https://dbquacks.com/challenges/athletic/29.md) — medium
- [Career Regression Alert](https://dbquacks.com/challenges/athletic/30.md) — hard
- [Hometown Performance Analysis](https://dbquacks.com/challenges/athletic/31.md) — medium
- [Misaligned Training Detection](https://dbquacks.com/challenges/athletic/32.md) — hard
- [Iron Duck Qualification](https://dbquacks.com/challenges/athletic/33.md) — hard
- [The Winter Edge](https://dbquacks.com/challenges/athletic/34.md) — medium
- [Relentless Cadence](https://dbquacks.com/challenges/athletic/35.md) — hard
- [Above Their Generation](https://dbquacks.com/challenges/athletic/36.md) — medium
- [Migration Discipline Order](https://dbquacks.com/challenges/athletic/37.md) — hard
- [The Steady Medalists](https://dbquacks.com/challenges/athletic/38.md) — medium
- [The Missing Water Drill](https://dbquacks.com/challenges/athletic/39.md) — medium
- [Cleared for Takeoff](https://dbquacks.com/challenges/athletic/40.md) — medium
- [Three in a Row](https://dbquacks.com/challenges/athletic/41.md) — hard
- [The Rescue Pair](https://dbquacks.com/challenges/athletic/42.md) — hard