Subscribe
Sign in
SQL Police Department — Learn SQL while solving crimes! Climb the ranks of SQL PD.
SQL Police Department is an online game where you solve crimes using SQL (and learn SQL on the way). As you solve more cases, you advance in the ranks of SQL Police Department and learn more SQL.
18
Replies
Best
Ariella
@doron_linder
1. Where is the ability to Sign Up? I only see Log In.
2. Can you check your answer for "White hat hacker has sent SQLPD exposed subscribers' details of a shady site connected to various persons of interest. Please submit the top 10 subscribers' details when sorted by hashed passwords in descending order and then by usernames in descending order."
I submitted an answer and it keeps saying that I have too many rows.
Report
Share
@ariella_cg
1. On the first screen, click on the "Buy a license" link. If you're already playing click on the profile tab (rightmost) and then click on "Buy a license" link.
2. The cases are randomly generated so each time it asks for different fields. If you get the "Unexpected rows" response it means (in this specific case) that your ordering is probably off which causes LIMIT to return different rows then expected. If you'll email me the brief and your query I'll be able to assist.
Thanks! It's fun. I wanted to try your product, but the site doesn't load. Do you know what the problem is?
@ann_bo The site is up. Are you trying to connect from Russia? If so, you should use a VPN. The censor there blanket blocked some cloud providers.
This is really cool! I have been trying to learn SQL from past one year but could not ace it. I hope this cool game will help me learn and ace the language.
I would say that it is a bit boring for advanced user. Maybe optimization queries would be great, like find why this query is slow (should be on TRY) .
It would be great to have detective help in solving case after 10 minutes or special button to solve the case with explanation.
I missing some story in background as well (but this is only my interpretation).
But for new people to learn SQL this is great.
Great Idea.
@john_tribe Thank you for the feeback :)
Guided help / explanation is a great idea!
The story would become more interesting once the queries are more complex (with joins for example).
Not sure yet if optimisation queries would be in scope. Maybe after all the basics are covered.
This is an interesting way to learn the basics of sql but I have to stress that it only covers the basics. It's still only beginner level sql and not worth $20. Once it covers intermediate and advanced concepts I can see it's value but for now I wouldn't recommend spending your money on it.
@brandon_hill2 The guide tab in the game shows what is currently supported. Over time, additional material will be added. As an early supporter you get longer license and lower price.
@strocolate1 There is no keyboard in the game. You should click on the command buttons and table / field names below to construct your query.
@max_hodges1 It's supposed to make it easier to construct queries on mobile. I'll see if I can give an option to use the keyboard without undermining this.
