SQLZOO:About

SQLZoo includes tutorials and reference to support people learning SQL. It features:

• Interactive access to several SQL engines
• Sample databases
• Practical exercise
• Instant feedback on the success of the student's attempts

Format

Here is an example of a question:

Warming up

Read the notes about this table. Observe the result of running a simple SQL command.

SELECT name, region, population FROM bbc

<source lang='sql' class='ans'>
SELECT name, region, population FROM bbc

Large Countries

Show the name for the countries that have a population of at least 200 million. (200 million is 200000000, there are eight zeros)

SELECT name FROM bbc
WHERE population>250000000

SELECT name FROM bbc
WHERE population>200000000

</source>