Difference between revisions of "SQLZOO:About"

From SQLZOO
Jump to navigation Jump to search
(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 ...")
 
Line 8: Line 8:
Here is an example of a question:
Here is an example of a question:


==Warming up==
==Warming up==
<div class='qu'>
<div class='qu'>
[[Read the notes about this table.]] Observe the result of running a simple SQL command.
[[Read the notes about this table.]] Observe the result of running a simple SQL command.
<source lang='sql' class='def'>
<source lang='sql' class='def'>
SELECT name, region, population FROM bbc
SELECT name, region, population FROM bbc
</source>
</source>
<source lang='html'>
<source lang='html'>
<source lang='sql' class='ans'>
<source lang='sql' class='ans'>
SELECT name, region, population FROM bbc
SELECT name, region, population FROM bbc
</source>
</source>
</div>
</div>
 
==Large Countries==
==Large Countries==
<div class='qu'>
<div class='qu'>
Show the name for the countries  that have a population of at least 200 million. (200 million is 200000000, there are eight zeros)  
Show the name for the countries  that have a population of at least 200 million. (200 million is 200000000, there are eight zeros)  
<source lang='sql' class='def'>
<source lang='sql' class='def'>
SELECT name FROM bbc
SELECT name FROM bbc
WHERE population>250000000
WHERE population>250000000
</source>
</source>
 
<source lang='sql' class='ans'>
<source lang='sql' class='ans'>
SELECT name FROM bbc
SELECT name FROM bbc
WHERE population>200000000
WHERE population>200000000
</source>
</source>
</div>
</div>
</source>

Revision as of 22:58, 8 June 2012

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