Puzzles Archives

Solving puzzles is a great way to learn SQL.  Nothing beats practicing what you’ve learned.

Once you have figured out the puzzle, post your answer in the comments so we all can learn from one another.

We also discuss puzzle and more in Essential SQL Learning Group on Facebook.  Be sure to find us there!

Here are two of my favorite puzzles you should try to solve:

All the examples for this lesson are based on Microsoft SQL Server Management Studio and the sample databases AdventureWorks and WideWorldImporters.

You can get started using these free tools using my guide Getting Started Using SQL Server

1

Rank Data with SQL

In this puzzle, we’re going to work through a problem to identify the top and bottom 25 percent to rank student scores. Solving puzzles is a great way to learn SQL.  Nothing beats practicing what you’ve learned. SQL Puzzle Question In today’s puzzle assume you’ve been asked by the head of the Mathematics department to […]

Continue reading
>