Show HN: SQL Noir – Learn SQL by solving crimes

Re:Show HN: SQL Noir – Learn SQL by solving crimes by rockfishroll on Thursday February 13, 2025 @07:38PM (#43043288)

I 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%'.

[ Parent | on HN ]

Re:Show HN: SQL Noir – Learn SQL by solving crimes by sprobertson on Thursday February 13, 2025 @09:12PM (#43043971)

That's how I solved #3, still trying to reverse-engineer the correct solution.

[ Parent | on HN ]

Re:Show HN: SQL Noir – Learn SQL by solving crimes by dylan604 on Friday February 14, 2025 @12:21AM (#43045114)

Isn't that the reversed method? You mean you're now trying to solve the crime the normal way instead of jumping to the last page of the book first?

[ Parent | on HN ]

Re:Show HN: SQL Noir – Learn SQL by solving crimes by sprobertson on Friday February 14, 2025 @08:04PM (#43054798)

Hmm it still feels apt, reverse-engineering anything is effectively starting at the last page of the book.

[ Parent | on HN ]

Re:Show HN: SQL Noir – Learn SQL by solving crimes by chrisBHappy on Friday February 14, 2025 @07:25AM (#43047680)

Haha. You found a cheat code I guess. I would have to think of hiding the answers from plain sight for the next cases or adding some more rows that include these specific strings.

[ Parent | on HN ]