Show HN: SQL Noir – Learn SQL by solving crimes (sqlnoir.com)

https://en.m.wikipedia.org/wiki/Mathnet

  select \* 
  from crime_scene;

  select \* 
  from crime_scene;
  --

  select ----from---------------- 

Badges for completing challenges.

Issue Closed, Won’t Fix.

Badges?? We don’t need no stinking badges!

I remember getting really into it, even going to the extreme of trying to find the most efficient one-liner solution.

Thanks for making this. I’ll be passing the torch by linking it to anyone interested in learning SQL.

One small thing which would be nice is the ability to just download the sqlite database myself so I could use my preferred application to query it, and just use the site for the brief, notes and submission.

Also a nitpick, while you say it's for "learning" SQL, I would probably expect something a little more guided, or at least some example queries, if the intention was to teach SQL. As it stands, if you don't know SQL you're probably going be completely lost as to what you should be doing. It's really cool, just not specifically as a learning tool.

By the way, I was trying to use a bunch of one-liner SQL statements to explore the data, and it seems like the editor doesn’t handle comments very well. Is there a way to make it work better?

I guess I’m used to sql server management studio I tried running multiple queries at once and wasn’t able to. I also tried writing a comment with two dashes to keep track of the id’s and it replaced most of my query with dashes. It might have something to do with being on mobile on iOS.

I see the beginnings of a really fun way to learn / practice / remember SQL.

A few notes:

- Would be cool if it was a single workspace (no tabs). Was constantly switching tabs back and forth.

- Saving previous SQL queries and results would be cool. I was copying results into the notes. Feel like this is important as things get more complex.

Excited to see where you take this!

education needs more stuff like this - less matter-of-fact regurgitation of information (which ai does an okay job of anyhow) and more creativity.

The results header is screwed up, there is an extra 'id' column. At least on firefox.

I've seen it advised to list table names as plurals as it holds more than one of the things. I've been told plural is dumb. I've not yet run into mixed plurals and singular table names. Sure, it's a style, but pick one???

I'm guessing this is like tabs vs spaces, but would a tab person use spaces randomly or vice versa?

otherwise, it's a fun way to kill some time. clearly, i played with it long enough to notice this little bitty bit of something. however, if only modern police departments had this ability to link clues. there's no way to drip donut cremes or spill coffee on these notes

It's hard to explain, but you can reproduce like this:

1. Write several lines, for example:

  select i.*, s.*
  from interviews i
  join suspects s
  on s.id = i.suspect_id

  -- select i.*, s.*
  from interviews i
  join suspects s
  on s.id = i.suspect_id



  -- select i.*, s.*
  -- from interviews i
  join suspects s
  on s.id = i.suspect_id