Thank you for the feedback. The SQL parsing is home made and I assumed fields in the order by clause is also a part of the SELECT. I collect a window of failed queries in memory (without knowing who sent what) to find cases like this and fix them.

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.

The cases are randomly generated; It asks for unique values of a random column in a random table. Sometimes it asks for unique password hashes... It's an edge case I didn't account for.

Interesting, why not hand pick the questions?

For replay-ability. Each time you need to understand the problem and construct a query instead of remembering that the answer was X (when I prototyped this in some of the cases you needed to pick the right answer from a cell in the table, not submit the whole thing).

Thanks for the feedback! I was wondering the same thing.

It can be solved with saving stuff to local storage, but I tried to not use it to be more GDPR compliant...

Isn't local storage pretty good for compliance? It doesn't automatically send the data to your server like a cookie would, so as long as you don't send it, you haven't collected it.

I have a hard time imagining a GDPR complaint in which storing ones own data on their computer would constitute a privacy violation

As long as you do not transmit the data ever, using localStorage isn't a GDPR concern other than that you should mention it (and the in-browser-only use, with data never leaving the users' systems) on your privacy policy page for the sake of transparency and to avoid users asking about it.

The first two are cases of selecting the whole table. Since it's (completely) randomised, there is a chance of getting the same table twice. I didn't account for that :-P If you solve it again, you'll get a new case following that.

Thanks! The game is still in development. It covers SELECT, DISTINCT, FROM (with one table), ORDER BY, LIMIT in the free part. After buying a license, WHERE, IN, BETWEEN, AND and OR are also covered. Check out the guide tab in the game - it covers everything supported so far. I plan on adding support for GROUP BY, aggregate functions, HAVING, aliases, JOINING multiple tables, and some more stuff with more complex cases to match.

The 6 months countdown doesn't begin until the game development ends so you're enjoying longer access.

Cool game, but I think pricing maybe a value issue. Might make more $$ if you just had a donation button, and some ads and maybe an option to upgrade to remove ads/donation nags. Plus you'd get a lot more word of mouth, and maybe add some social sharing of 'accomplishments' etc...

Currently the first rank is 11 cases, and the second rank is 20 additional cases. The second rank covers WHERE with numbers, strings, dates and timestamps, IN, BETWEEN, AND and OR. Check out the guide tab in the game - it covers everything supported so far. Once you finish that, you go into practice mode where you're randomly asked the same kind of cases like the previous ones. I plan on adding support for GROUP BY, aggregate functions, HAVING, aliases, JOINING multiple tables, and some more stuff with more complex cases to match.

And the 6 months countdown doesn't begin until the game development ends so you're enjoying longer access.

Yeah, the semicolon bothers me too. I'll see how I can incorporate that in. The clicking around was meant to make life easier on mobile phone users. I'll see if I can add a keyboard support without undermining this.

This makes a lot of sense, actually. Definitely great for learning.

You could do it the way Duolingo does it - on desktop, it allows for "Hard Mode", where it lets you type the responses freely. On mobile however, it doesn't let you do that (unless you're using the app).

Currently the first rank is 11 cases, and the second rank is 20 additional cases. The second rank covers WHERE with numbers, strings, dates and timestamps, IN, BETWEEN, AND and OR. Check out the guide tab in the game - it covers everything supported so far. Once you finish that, you go into practice mode where you're randomly asked the same kind of cases like the previous ones.

I plan on adding support for GROUP BY, aggregate functions, HAVING, aliases, JOINING multiple tables, and some more stuff with more complex cases to match.

And the 6 months countdown doesn't begin until the game development ends so you're enjoying longer access.

I think it would be more compelling to see how much more material there is, or at least how much is planned, like a timeline or map. I'm a little hesitant to purchase it blind.

That would convince me to pay for this