SQLZoo

Solutions to the SQL questions on https://sqlzoo.net/wiki/SQL_Tutorial

0 SELECT basics

Some simple queries to get you started

1 SELECT name

Some pattern matching queries

2 SELECT from World

In which we query the World country profile table.

3 SELECT from Nobel

Additional practice of the basic features using a table of Nobel Prize winners.

4 SELECT within SELECT

In which we form queries using other queries.

5 SUM and COUNT

In which we apply aggregate functions. more the same

6 JOIN

In which we join two tables; game and goals. previously music tutorial

7 More JOIN operations

In which we join actors to movies in the Movie Database.

8 Using Null

In which we look at teachers in departments. previously Scottish Parliament

8+ Numeric Examples

In which we look at a survey and deal with some more complex calculations.

9- Window function

In which we examine UK general election results.

9+ COVID 19

In which we measure the impact of COVID-19

9 Self join

In which we join Edinburgh bus routes to Edinburgh bus routes.

10 Tutorial Quizzes

Test your knowledge with multiple choice quizzes

11 Tutorial Student Records

Creating a database

12 Tutorial DDL

Instructions on how to import data and analyse it in mysql