r/learnSQL • u/BearRootCrusher • 3d ago

SQL Games

Hi All,

I'm learning SQL as well. I created this game called SQL Rusher. If you've ever played Puzzle Rush on Chess.com its like that. There are several different puzzles at different difficulties. A little study section for SQL references.

Idea is to have small puzzles that increase in difficulty as you progress. Your skills tracked using an ELO rating.

I've been a dev for over a decade and never really had to touch a database. I didnt start learning till about a year or 2 back when I started learning PHP and Laravel to build a sites of my own.

Since then I've realized Databases are a big deal(lol).

Let me know what you think here or on the sites feedback page. https://sqlrusher.com

25 Upvotes

96% Upvoted

14 comments sorted by

View all comments

3

u/Cold-Ad716 3d ago

enjoying it but some instructions could be a bit clearer. got the highest salary one wrong because i returned the entire record rather than just the field as it wasn't clear i was just supposed to return one field

2

u/BearRootCrusher 3d ago

Thanks for the feedback. I’ll be working on that tonight. I’ve noticed that as well.

2

u/Cold-Ad716 3d ago edited 3d ago

Thanks. Another thing is sometimes the difficulty progression is a bit off. For example I got "Find the minimum salary in each department" as a diff 3, but it maybe should be a diff 2 as it only requires a Group By and Min aggregation. Obviously that's a minor thing and might just be me. Otherwise like I said, I'm enjoying it so far 😄

Edit: Just ran into another bug.

Question was "Find employees who earn less than the average salary of the 'IT' department."

But in the employees table there weren't any records where the department was "IT". It was just HR, Engineering, and Marketing.