Programming @programming.dev SlIdE42 @jlai.lu 2w ago

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

Heck yeah
- Push it to the LIMIT
  
  SELECT few FROM people WHERE gets_joke = 1
- I’m a rebel. I write all my sql in lowercase
  
  Yeah we have IDEs to color keywords for us these days. Caps is just extra work
If you're new to SQL there's interactive Select Star SQL tutorial. And there's another detective — SQL Murder Mystery
- 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
Relevant:
- Alt text:
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