Hello. I am Scott Peters, located in Austin, Texas. I am a purveyor of SQL puzzles! Please feel free to contact me using the contact form on my website. I love hearing from everyone.
Welcome to my SQL puzzle website. I hope you enjoy solving these puzzles as much as I have enjoyed creating them.
All solutions to the puzzles are written in Microsoft SQL Server’s T-SQL, but you can quickly adapt the solutions to your flavor of SQL. I’m constantly adding new material, so scroll through to find a wide range of database tips, tricks, and insights.
I also welcome any corrections, new tricks and techniques, dead links, misspellings, bugs, and any new puzzles you think would be great for this blog.
Let’s get on to the puzzles…
Advanced SQL Puzzles
Here is a collection of the most challenging set-based SQL puzzles I could devise, neatly condensed into a GitHub markdown file. This is a great starting point for determining your expertise with SQL. I highly recommend that developers of all skill levels work through this puzzle set; you may be surprised by the results.
Link to my GitHub repository below.
On my GitHub, I also have a collection of my writings on various database topics, as well as a number of scripts that contain helpful tips and tricks I’ve coded along the way. Feel free to rummage around and grab anything you can use.
Take the SQL Quiz Challenge
I created a set of advanced multiple-choice SQL quiz questions and loaded them into a quiz-making application. I have several hundred questions so far.
Python Puzzles
I also started a WordPress page for my Python puzzles. These are probability puzzles that involve applying statistical concepts, such as the law of large numbers, to perform hacker statistics.
Data Analytics
This is where I keep my various data analytics projects. This primarily includes descriptive and inferential statistical projects I’ve created, as well as some machine learning models I’ve built.
Blog
I also keep a blog here. I really should spend more time updating it.
Happy coding!!