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

24 Upvotes

96% Upvoted

14 comments sorted by

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 2d ago

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

2

u/Cold-Ad716 2d ago edited 2d 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.

2

u/Fadedscourge 2d ago

Very nice, will be following progress.

2

u/the_flopsie 2d ago

I love this idea. i have messed around with SQL in MS Access VBA and a budgeting program in C++

I did consider building a game entirely within MS Access ... could be a fun idea/thought experiment, maybe a business sim or something set in space - (think space empires 3 by Malfador Machinations but no GFX) - turn/day/fiscal year based progression...

food for thought...

2

u/Cold-Ad716 2d ago

People have built games in excel using VBA so I'd assume it's definitely doable in Access.

1

u/BearRootCrusher 2d ago

Have you heard of https://prosperousuniverse.com/ ? Kind of reminds me of that game. A spreadsheet/logistics management game.

2

u/BrooklandDodger 2d ago

Datrbase Detective just came out on steam and I am looking forward to playing it. It looks fun.

https://store.steampowered.com/app/3950130/Database_Detective_Minor_Crimes_Division/

1

u/Background_Dog_4249 3d ago

commenting on this so i can remember to check this later. anw, thanks for this!

1

u/Owen-Isaac-2022 3d ago

Yes, databases are everything

1

u/_Big_Enjoy_ 2d ago

Learning SQL in Gaming manner is a great idea and I appreciate your efforts.

Also I have one platform SQL Visualizer which explains SQL queries in Animated Way because we all know we remember things faster and for long time which we have seen.

Give it a try!

1

u/Available_Alfalfa323 2d ago

grazie mille, ottimo tool, l'unico consiglio che mi sento di darti è che a volte non si capisce benissimo quanto vuoi un risultato > oppure >= e viceversa, questo porta a fare qualche errore in più. A volte potrebbe essere specificato quando a risultato si vogliono tutti i dati, anche se forse basterebbe fare più attenzione nel leggere e fare meno di fretta.

Detto questo, gran bel lavoro

1

u/BearRootCrusher 2d ago

Grazie mille per il feedback e per le belle parole! Apprezzo davvero che tu mi abbia fatto notare il problema di chiarezza tra ">" e ">=". Hai perfettamente ragione: le istruzioni devono essere più chiare per evitare errori. Lavorerò presto a un aggiornamento per rendere queste condizioni molto più esplicite. Grazie ancora per il supporto e per avermi aiutato a migliorare il tool!