51–60 of 82 posts
I've never come across an "SQL game" before, this was great fun! I got it in around 15 minutes though, really wish there was a bit more too it, or that more complex queries were required.
OMG I love this. I just sent it to my buddy who as a PM is learning SQL to not rely on the BI team since the turnaround can be days. Ultra tiny desire - I only wish there was more on the story line/intro framing. Took at look at the schema and was like "What is Get fit now? - ohhhh, it's a gym... got it..."
well for me not looking at the schema made it more fun and I guess the plot was also pretty involving ^^
> ... not looking at the schema ...
Ah, fond memories :) I once made a javascript implementation of an sql engine for a weekend game. http://ludumdare.com/compo/ludum-dare-27/?action=preview&uid... It was a very long time ago and, then, everyone was wondering where Snowden was. I think this was after he was identified, and just before he ended up in Russia. Anyway, you are given an NSA Prism terminal, complete with Windows 95 look and feel and a paperc…
From the better link from kevindong: "A crime has taken place and the detective needs your help. The detective gave you the crime scene report, but you somehow lost it. You vaguely remember that the crime was a murder that occurred sometime on Jan.15, 2018 and that it took place in SQL City . Start by retrieving the corresponding crime scene report from the police department’s database."
This type of gamification is awesome and as someone who loves coding but doesn't find Sudoku's or whatever very enjoyable, I would love a place I could do little coding challenges like this in break times!
Anyone know of any? I'm thinking "Escape Rooms" via coding could be a big thing!
I always wanted do invest my 20 hrs into SQL. I've already put 10 with a data analyst course so i know what a sqlite , select and joins are. I've created a not trivial query once. Is this OK for learn some more ?
[0]: https://mystery.knightlab.com/walkthrough.htmlhttps://myster...
reminds me of the command line / unix tools murder mystery https://github.com/veltman/clmystery
We love that people are enjoying this so much, so we're also grateful to Simon Willison for reviving attention on the original project, and Zi Chong Kao, whose SQL tutorial site showed us the possibility of mounting the whole thing in a browser page.
(I'm the person who guided the Knight Lab students' original work and ported it to the web hosted version at mystery.knightlab.com)