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%'.
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.
That's how I solved #3, still trying to reverse-engineer the correct solution.
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?
Hmm it still feels apt, reverse-engineering anything is effectively starting at the last page of the book.