I've started playing around with SQL (specifically MySQL) thanks to these
basic tutorials. I started using the Sakila
sample database so I would have some decent data to work with. I managed a few basics, but it's definitely a use it or lose it situation, and I don't have anything to use it on! I'd like to practice writing SQL queries for realistic problems on a realistic data set and find out if I got the right output.
So: has anyone run across some good web resources for SQL exercises? I've run out of scenarios I can invent based on the Sakila database, and there's no guarantee that I'm getting the right result with my joins anyway. Ideally I'd like a resource that poses a problem to solve with SQL and will tell me what the correct answer (i.e., the correct output of my queries) is once I've tried to solve it on my own. I'm not looking for anything fancy, just "Here's a data set. Try to answer [question] about the data. Here's what you should have gotten, and how you should have gotten it."
If there aren't any online resources for this, suggestions for a book of exercises are welcome, though (as with everything on AskMe) free is always better!