Skip to content
Advanced SQL Puzzles

Advanced SQL Puzzles

Thinking In Sets

  • Home
  • Contact

Tag: SQL Puzzles

First and Last Values

Hello, here is a puzzle that makes perfect use of the FIRST_VALUE, LAST_VALUE, LAG, and the MIN functions. For the following dataset, you need to find the difference between each player's first score against the current score, as well as their last score against the current score. If their score improved from their previous score, … Continue reading First and Last Values →

Scott Peters Uncategorized Leave a comment January 14, 2023February 3, 2023

Scott Peters

Welcome to my SQL Puzzle website.  I hope you enjoy solving these puzzles as much as I have enjoyed creating them. All solutions are written in Microsoft SQL Server T-SQL, but can be easily modified to fit your flavor of SQL. I also have quite a few tips, tricks and learning materials available if you scroll through my blog.  I try to keep things to the advanced level and not recreate the already abundant amount of SQL resource materials available. I have also started incorporating Python puzzles in my blog as well.  Many of them are riddles and hacker statistics that are better solved in Python. Feel free to contact me with any new puzzles that would be a great for this blog.

Quick Links

Advanced SQL Puzzles

Python Puzzles  

GitHub

Copy and Paste

Blog

Contact Information

Contact Form

Go to mobile version
 

Loading Comments...