Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

SQL Murder Mystery

mystery.knightlab.com

Post reply on HN
Print view View original

61–70 of 82 posts

Re: SQL Murder Mystery

#61

Post by bbaumgar »

vyper91 wrote: post #58

As I have a working knowledge of SQL this was very simple but my friends who use it sparsely in their financial jobs had a blast racing each other. 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 b…

This only applies during December, but https://adventofcode.com/ is a fun experience! Most puzzles range from 30 minutes to 3 hours from start to finish.

Re: SQL Murder Mystery

#62

Post by ehou »

vyper91 wrote: post #58

As I have a working knowledge of SQL this was very simple but my friends who use it sparsely in their financial jobs had a blast racing each other. 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 b…

My guess is when you don't make it a hard core coding thing but more of a general search quest it would be more succesful. Like in this case: you need to have a search function / filter options on those tables. Even transfering it to Excel (the horror) would increase the target population with huge factor.

Re: SQL Murder Mystery

#63

Post by PascLeRasc »

vyper91 wrote: post #58

As I have a working knowledge of SQL this was very simple but my friends who use it sparsely in their financial jobs had a blast racing each other. 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 b…

Here's a super fun one where you SSH into different servers and have to use Bash/unix tools to find clues to get to the next one: https://overthewire.org/wargames/bandit/

Re: SQL Murder Mystery

#65

Post by JoeGermuska »

hultner wrote: post #51
GordonS wrote: post #49

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.

I haven't played it but I'm intrigued by the idea. This is MIT so forking it and creating sequel mysteries wouldn't to far fetched.

we'd love to see that happen!

And really, the most valuable piece, IMO, are the SQL web components, from SelectStarSQL, which are CC0 public domain.

Re: SQL Murder Mystery

#66

Post by codezero »

vyper91 wrote: post #58

As I have a working knowledge of SQL this was very simple but my friends who use it sparsely in their financial jobs had a blast racing each other. 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 b…

I was thinking of bringing this challenge into a team meeting. How fast were folks able to solve it on average?

Answering my own question, 10-20 minutes if you're pretty basic at SQL :)

Re: SQL Murder Mystery

#68

Post by ct0 »

cyborgx7 wrote: post #54

I'm lazy, so for both the first and second stage I narrowed down the selection to 2 to 3 people and then tried them all.

You were about one join away from narrowing it down to the killer.

Re: SQL Murder Mystery

#69

Post by ct0 »

reagent_finder wrote: post #35
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."

Whaaat, I wasn't supposed to muck around the DB for 5 minutes trying to find the starting point?

Were you successful at solving the puzzle without the starting clues?
Post reply on HN