Show HN: SQL Police Department – Learn SQL while solving crimes

Re:Show HN: SQL Police Department – Learn SQL while solving ... by jonny_eh on Monday May 04, 2020 @12:58PM (#23070452)

The question where it asks for the list of unique download counts makes no sense.

[ Parent | on HN ]

Re:Show HN: SQL Police Department – Learn SQL while solving ... by doronlinder on Monday May 04, 2020 @03:39PM (#23072386)

The cases are randomly generated; It asks for unique values of a random column in a random table. Sometimes it asks for unique password hashes... It's an edge case I didn't account for.

[ Parent | on HN ]

Re:Show HN: SQL Police Department – Learn SQL while solving ... by jonny_eh on Monday May 04, 2020 @05:13PM (#23073339)

Interesting, why not hand pick the questions?

[ Parent | on HN ]

Re:Show HN: SQL Police Department – Learn SQL while solving ... by doronlinder on Monday May 04, 2020 @06:31PM (#23074139)

For replay-ability. Each time you need to understand the problem and construct a query instead of remembering that the answer was X (when I prototyped this in some of the cases you needed to pick the right answer from a cell in the table, not submit the whole thing).

[ Parent | on HN ]