I literally can't get past the first level and I have no idea why.
click on GUI. click SELECT click * click FROM click mailing_list click run
[deleted]
Show HN: SQL Police Department – Learn SQL while solving crimes
21–30 of 91 posts
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#22It's great! I would buy a licence but I don't know how many cases do you have altogether?
Same. And on 50% discount.
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#23Perhaps I'm missing something but I can't seem to find what I get for my money, what concepts and commands are covered? How many "cases" are there?
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#24I love it that was a fun past time ;)
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#25This is a cool idea but if you accidentally hit the back button or refresh it loses all your progress with no obvious way to skip ahead. Frustrating.
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#26Nice 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.
I agree. I work in Microsoft's SQL Server (incl. variations, e.g. Azure SQL DW) quite a bit. Based on my experience, I am the only person using semicolons in T-SQL.
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#27This looks great! It was difficult to find out that you had to click the Play button for me "▷". Since this is a primary action you might want to consider adding a stronger Call to Action there?
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#28This seems like a neat idea. Not sure about paid, though, in its current incarnation. There's a ton of similar things unpaid. Why would I pay for this over Khan Academy's excellent SQL course, for example?
It seems like a piece of a business, not a business in itself. To be successful as a product or solution, there needs to be more around it -- some way to integrate it into contexts, have it used in schools, or in afterschool, or something.
Another key component would be user studies -- develop PCK about what supports and help students need.
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#29Are the names and email addresses in the sample data real? They seem auto generated but the domains are real providers like Hotmail, Gmail, and Outlook.
Everything is randomised, nothing is based real data. It's auto generated from popular first names, last names, changing patterns and random years or numbers attached at the end. Domains are real, but randomised as well.
It's kinda risky in my opinion. I just checked a few of the addresses (mostly the one's without any numbers at the end), some of them do actually belong to real people.
Re: Show HN: SQL Police Department – Learn SQL while solving crimes
#30Cool concept but the license seems kind of weird to me. 20 bucks for six months? Will anything change in that time? You might want to add a bit of info on what the license gets you.