Hello. I am Scott Peters. Located in Austin, Texas. Purveyor of SQL puzzles! Feel free to contact me via the website’s contact form, 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.
Link to my GitHub repository below:
All solutions to the puzzles are written in Microsoft SQL Server’s T-SQL, but you can easily adapt the solutions to your flavor of SQL. I’m constantly adding new material, so scroll through to find all sorts 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 difficult set-based SQL puzzles I could write, nicely condensed into a PDF file. This is a great starting point to determine your level of expertise with SQL. I highly recommend developers of all skill levels work through this puzzle set; you may be surprised!
Link to my GitHub repository below.
In my GitHub, I also have a collection of my writings on various database topics and a bunch of my scripts that are 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 wrote a bunch of advanced multiple-choice SQL quiz questions and loaded them into a quiz maker application. I have several hundred questions so far, and the list is growing.
I also started a WordPress page for my Python puzzles. These are probability puzzles where you perform hacker statistics using the law of large numbers.
Here is where I keep the various data analytic projects I have done. This mainly includes descriptive and inferential statistical projects I’ve created and some machine learning models I have built.
I also keep a blog here. I try to update this every couple of weeks. Check back often.