SQLZOO:About

From SQLZOO
Revision as of 22:57, 8 June 2012 by Andr3w (talk | contribs) (Created page with "SQLZoo includes tutorials and reference to support people learning SQL. It features: *Interactive access to several SQL engines *Sample databases *Practical exercise *Instant ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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>