haha this is such a cool aesthetic! nice work.
education needs more stuff like this - less matter-of-fact regurgitation of information (which ai does an okay job of anyhow) and more creativity.
Show HN: SQL Noir – Learn SQL by solving crimes
31–40 of 90 posts
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#32I solved all of them. Minor nitpick: Since every criminal confesses to their crime, the fastest way to solve most of these is to query the confessions table for strings like '%i did%' or '%kill%'.
That's how I solved #3, still trying to reverse-engineer the correct solution.
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#33This gives me a childhood flashback to a show called MathNet, an educational police procedural (a la Dragnet) where both investigators have holstered calculators. https://en.m.wikipedia.org/wiki/Mathnet
I cannot even tell you how many glorious memories this brings up! Thanks for a walk down memory lane.
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#34On case #4:
select *
from phone_records
where
caller_id= 11 or recipient_id = 11
The results header is screwed up, there is an extra 'id' column. At least on firefox.
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#35I'm on mobile, so maybe I'm missing something, but I don't understand how youbare even supposed to get started without knowing SQL. If this is supposed to teach SQL then there needs to be some tutorial to guide the way.
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#36I'm on mobile, so maybe I'm missing something, but I don't understand how youbare even supposed to get started without knowing SQL. If this is supposed to teach SQL then there needs to be some tutorial to guide the way.
Agreed, but there is a suggested query to get you started at each step.
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#37Just wanted to say this is awesome! sent it to a few coworkers
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#38How do you make money doing this and if you earn nothing, how can you afford to in this economy?
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#39How do you make money doing this and if you earn nothing, how can you afford to in this economy?
The bitterness is palpable.
Re: Show HN: SQL Noir – Learn SQL by solving crimes
#40How do you make money doing this and if you earn nothing, how can you afford to in this economy?
[deleted]