Solutions to the SQL questions on https://sqlzoo.net/wiki/SQL_Tutorial
Some simple queries to get you started
Some pattern matching queries
In which we query the World country profile table.
Additional practice of the basic features using a table of Nobel Prize winners.
In which we form queries using other queries.
In which we apply aggregate functions. more the same
In which we join two tables; game and goals. previously music tutorial
In which we join actors to movies in the Movie Database.
In which we look at teachers in departments. previously Scottish Parliament
In which we look at a survey and deal with some more complex calculations.
In which we examine UK general election results.
In which we measure the impact of COVID-19
In which we join Edinburgh bus routes to Edinburgh bus routes.
Test your knowledge with multiple choice quizzes
Creating a database
Instructions on how to import data and analyse it in mysql