SQL Practical for A-level CS

Teaching the Databases topic to an A-level class, I have made these tasks and suggested solutions in REPL.it.

1. First teach the basics of SQL e.g. using Craig n Dave’s video here: OCR A-level SQL
2. Check for understanding of the basics e.g. by asking a few basic SQL query questions, using a quick quiz like this: W3Schools SQL Quiz or better still, use the premium resources from Craig n Dave that are intended to follow the above video lesson.
3. Share the skeleton code here repl.it/@mraharrison/sqlite1 with the students. Explain the code. (Needs you to be familiar with it, so read through it and try it out first!).
4. Optionally walk through the first one or two problems and code the solution live with them.
5. Assign as homework, or continue as a lesson, whatever you are more comfortable with.
6. Use the suggested solutions here when stuck, or share this with the students after they have attempted the problems. repl.it/@mraharrison/sqlite1-solutions-1

Feedback welcome on Twitter or in the comments. Thanks.