SQL Noir
SQL Noir
www.sqlnoir.com SQL Noir - A Detective SQL Game
Solve crimes and mysteries using SQL queries in this detective-themed SQL learning game.
Solve mysteries through SQL.
19 comments
-
If you're new to SQL there's interactive Select Star SQL tutorial. And there's another detective — SQL Murder Mystery
-
I know what I'm doing at work today
-
My gosh, these are incredible. Thank you for sharing them. I cried at Select Star; that is legitimate art.
-
I have some time to kill before having to run some errands. I've started with the first one and it's pretty fun!
Said "fuck yeah" a couple times to myself when I got the answer right. I've not used SQL before but I've got a decent grasp (as in I get the basics) on programming languages so it's somewhat intuitive to me
Thanks for the links!! I look forward to continuing when I get back
-
-
I tried to hit F5 to run a query and it refreshed the page lol
edit: I'm also slightly annoyed that the table names are a mix of singular and plural
-
That totally threw me off. “Literally unplayable,” as they say.
-
-
Good stuff
-
This seems like it was made specifically for me and my interests.
-
seems like there's an issue with case 3. the person_id and from surveillance_records doesn't match up with the person_id in the hotel_checkins table when joined on hotel-checkin_id
-
Yep, surveillance_records.person_id is the same as surveillance_records.id, which is incorrect. I looked at the Github repo and there's already a report for it.
What I don't understand (and apparently this is my problem, not a bug) is how we're supposed to narrow the list down to three suspects in the next-to-last step, as the "Case Solved" text describes (Yeah, I cheated). The interviews with the two witnesses give a partial hotel name and a check-in date, but that returns dozens of results. The ending messsge congratulates us for reducing that list by using the surveillance records in some way, but I can't see how. The only other detail I have is "The guy looked nervous", which doesn't seem to have any connection with the surveillance records.
-
19 comments