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