Live data from Hacker News

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

sqlpd.com

71–80 of 91 posts

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

#71
post #8

Worth considering capturing the keyboard input. I instinctively hit "delete" partway through to delete something I had clicked on and it took me back to HN and I lost my progress.

do you ever actually use backspace to go back a page? If not, turn it off in your browser settings, since you'll only ever use it accidentally anyway. (And what's more, you'll only ever use it accidentally while you're trying to edit text you've input .) to me backspace going back a page = a sense of frustration. better to turn it off in the browser, so I did so.

Good call. I use ⌘-← all the time to go back but never backspace

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

#75
post #19

Nice concept but I really hate clicking on the buttons to form my statements... Is it possible to allow typing? Also, not ending my statement with a semicolon feels incomplete.

Yes! Part of learning a language, for me, is gaining muscle memory with my fingers and having to use a mouse is a turn off. Very cool site otherwise!

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

#78

>"A mailing list of an illegal online service was sent to the SQLPD hot-line. Please submit all records email addresses' details. Please make sure there are no duplicates." typo

I'm missing it. Where's the typo?

records is possessive and should have the apostrophe, addresses is not possessive and should not. This class of typo is pretty common throughout the briefs I have looked at.

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

#80

  SELECT Email
  FROM mailing_list
  ORDER BY JoinDate

  SQL Error: There is no field named JoinDate in the resulting FROM table.
Ok? What engine is this using? That's valid SQL in my universe.

In PostgreSQL 12:

  mulmen@shell> psql
  psql (12.1)
  Type "help" for help.

  mulmen=# CREATE TABLE foo ( bar INT, baz INT );
  CREATE TABLE
  mulmen=# INSERT INTO foo VALUES (1, 10), (2, 20);
  INSERT 0 2
  mulmen=# SELECT bar FROM foo ORDER BY baz;
   bar
  -----
     1
     2
  (2 rows)

  mulmen=#
Post reply on HN