Difference between revisions of "SQLZOO:About"

From SQLZOO
Jump to: navigation, search
(3 intermediate revisions by one user not shown)
Line 9: Line 9:
  
 
  ==Warming up==
 
  ==Warming up==
  <div class='qu'>
+
  &lt;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'>
+
  &lt;source lang='sql' class='def'>
 
  SELECT name, region, population FROM bbc
 
  SELECT name, region, population FROM bbc
  </source>
+
  &lt;/source>
  <source lang='html'>
+
  &lt;source lang='sql' class='ans'>
<source lang='sql' class='ans'>
+
 
  SELECT name, region, population FROM bbc
 
  SELECT name, region, population FROM bbc
  </source>
+
  &lt;/source>
  </div>
+
  &lt;/div>
+
 
==Large Countries==
+
And here is how that looks when rendered...
<div class='qu'>
+
==Warming up==
Show the name for the countries  that have a population of at least 200 million. (200 million is 200000000, there are eight zeros)
+
<div class='qu'>
<source lang='sql' class='def'>
+
[[Read the notes about this table.]] Observe the result of running a simple SQL command.
SELECT name FROM bbc
+
<source lang='sql' class='def'>
WHERE population>250000000
+
SELECT name, region, population FROM bbc
</source>
+
</source>
+
<source lang='sql' class='ans'>
<source lang='sql' class='ans'>
+
SELECT name, region, population FROM bbc
SELECT name FROM bbc
+
</source>
WHERE population>200000000
+
</div>
</source>
+
 
</div>
+
 
 +
{{Languages}}

Revision as of 20:58, 21 August 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==
<div class='qu'>
Read the notes about this table. Observe the result of running a simple SQL command.
<source lang='sql' class='def'>
SELECT name, region, population FROM bbc
</source>
<source lang='sql' class='ans'>
SELECT name, region, population FROM bbc
</source>
</div>

And here is how that looks when rendered...

Warming up

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

SELECT name, region, population FROM bbc
SELECT name, region, population FROM bbc


Language: English  • Deutsch
Personal tools

Variants
Actions
Reference
Toolbox
Google AdSense