I'm having a repeated problem with the SQL courses in Codecademy. I get to an exercise where they're asking me to do a pretty complex query. My preferred way of working out the problem is to start with a component of it, a simpler query, and play around with the database until I can get back the more complex result. But when I do this on Codecademy, every time I do a query that doesn't provide the answer, I get a popup and it keeps asking me if I want to give up.
I've been thinking maybe what I should do is recreate the schema on my own machine in MySQL workbench or something so that I can play around in peace and return to codecademy when i have the answer.
Has anyone else felt the same way? Is there an easy way to download the schema and/or data or do I have do build from scratch?
Replace this line with your code.