Show HN: I made a SQL game to help people learn / challenge their skills
Great idea, SQL is an undervalued skill<p>Feedback:<p>I did this exercise:<p><a href="https://lost-at-sql.therobinlord.com/challenge-page/case" rel="nofollow">https://lost-at-sql.therobinlord.com/challenge-page/case</a><p>The specification says:<p>> Clownfish are between 3-7 inches in length, weigh around half a pound, and live in the coral reef.<p>around half a pound is meaningless, the spec should be exact.<p>It was annoying having to scroll from the input at the bottom of the page to the specification at the top of the page to refer to it.<p>The test cases are insufficient. I only wrote this:<p>> select
  *,
  CASE WHEN species_name = "clownfish" AND length NOT BETWEEN 3 AND 7 AND weight != .5 AND habitat_type != "coral reef" THEN "imposter"
  ELSE "not imposter" END imposter_status from marine_life;<p>And passed the check at the end.<p>I didn't like that it kept track of the number of syntax errors and how long it took me to finish, that doesn't seem conducive to learning/practicing.<p>There seemed to be a lot of preamble to get to the challenge page. It seems like those should be linked directly from the homepage.<p>The format button didn't work on my code above.<p>Syntax highlighting seems broken for some functions, like IIF.<p>It would be nice if multiple SQL dialects were supported, forcing SQLite makes this more of an exercise in 'translate the dialect you know into SQLite'.<p>I didn't love the challenge I did overall, it was a single CASE statement, which seems to be testing logic more than any SQL knowledge. Maybe because it's a warmup?