SQL Murder Mystery • Hacker News Board

Re: SQL Murder Mystery

#11

Post by dlgeek » Mon, Dec 16, 2019, 2:00 AM UTC

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."

Re: SQL Murder Mystery

#12

Post by merciBien » Mon, Dec 16, 2019, 2:03 AM UTC

I love this type of story-based learning! I was playing with twilioquest this weekend, I really appreciate the developers’ creativity. How can I find more tools like these?

Re: SQL Murder Mystery

#13

Post by [deleted] » Mon, Dec 16, 2019, 2:08 AM UTC

[deleted]

Re: SQL Murder Mystery

#14

Post by dlgeek » Mon, Dec 16, 2019, 2:10 AM UTC

ihunter2839 wrote: post #9

I played along on the web based ui but for the life of me can't figure out how to check my solution? I see that there is an insert statement given on the github page but I get a 'Statement must be a SELECT' error when I try to execute it. What am I missing?

Ditto. Following the link given in sibling comment, I see the same instruction, but the insert fails with the same error.

EDIT: Running the queries from the other URL (http://mystery.knightlab.com/) works. Admins, you should change the URL to this one.

Re: SQL Murder Mystery

#15

Post by kroltan » Mon, Dec 16, 2019, 2:10 AM UTC

Just spent some nice 30 minutes figuring it out, got the bonus ending too! It's a very cool concept for a game! Wish it was a bit longer.

Re: SQL Murder Mystery

#16

Post by rrix2 » Mon, Dec 16, 2019, 2:13 AM UTC

This version doesn't support INSERTing the solution from the web. https://mystery.knightlab.com does, though, and provides some guidance out the door.

Fun little thing, thanks!

Re: SQL Murder Mystery

#17

Post by gucciTheWizard » Mon, Dec 16, 2019, 2:16 AM UTC

merciBien wrote: post #12

I love this type of story-based learning! I was playing with twilioquest this weekend, I really appreciate the developers’ creativity. How can I find more tools like these?

If you're into logic puzzles and python, I built Jindosh.com. If you like javascript, there's this great game at https://alexnisnevich.github.io/untrusted/

Re: SQL Murder Mystery

#18

Post by pbiggar » Mon, Dec 16, 2019, 2:24 AM UTC

Be warned that there are spoilers built into the DB, if you look too closely. The trigger on the solution DB has the answer built into the SQL, as I learned when I ruined the game for myself.

Re: SQL Murder Mystery

#19

Post by dbravender » Mon, Dec 16, 2019, 2:35 AM UTC

I accidentally revealed the solution after running the .schema command (the solution is in the trigger code on that table). ️ Might be a record though - I got the answer in only a few seconds.

Re: SQL Murder Mystery

#20

Post by cyberferret » Mon, Dec 16, 2019, 2:44 AM UTC

dlgeek wrote: post #11

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."

Thanks! This was the key sentence missing from the original link. I hadn't a clue what I was supposed to be looking for, but this is the minimum info needed to get started. (NB: Solved it in a few minutes after I think 8 queries - though I could have combined a couple I think, for even less queries)