Difference between revisions of "SQLZOO:About"

From SQLZOO
Jump to: navigation, 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 23: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

Invalid language.

You need to specify a language like this: <source lang="html4strict">...</source>

Supported languages for syntax highlighting:

4cs, 6502acme, 6502kickass, 6502tasm, 68000devpac, abap, actionscript, actionscript3, ada, algol68, apache, applescript, apt_sources, asm, asp, autoconf, autohotkey, autoit, avisynth, awk, bascomavr, bash, basic4gl, bf, bibtex, blitzbasic, bnf, boo, c, c_loadrunner, c_mac, caddcl, cadlisp, cfdg, cfm, chaiscript, cil, clojure, cmake, cobol, coffeescript, cpp, cpp-qt, csharp, css, cuesheet, d, dcs, delphi, diff, div, dos, dot, e, ecmascript, eiffel, email, epc, erlang, euphoria, f1, falcon, fo, fortran, freebasic, fsharp, gambas, gdb, genero, genie, gettext, glsl, gml, gnuplot, go, groovy, gwbasic, haskell, hicest, hq9plus, html4strict, html5, icon, idl, ini, inno, intercal, io, j, java, java5, javascript, jquery, kixtart, klonec, klonecpp, latex, lb, lisp, llvm, locobasic, logtalk, lolcode, lotusformulas, lotusscript, lscript, lsl2, lua, m68k, magiksf, make, mapbasic, matlab, mirc, mmix, modula2, modula3, mpasm, mxml, mysql, newlisp, nsis, oberon2, objc, objeck, ocaml, ocaml-brief, oobas, oracle11, oracle8, oxygene, oz, pascal, pcre, per, perl, perl6, pf, php, php-brief, pic16, pike, pixelbender, pli, plsql, postgresql, povray, powerbuilder, powershell, proftpd, progress, prolog, properties, providex, purebasic, pycon, python, q, qbasic, rails, rebol, reg, robots, rpmspec, rsplus, ruby, sas, scala, scheme, scilab, sdlbasic, smalltalk, smarty, sql, systemverilog, tcl, teraterm, text, thinbasic, tsql, typoscript, unicon, uscript, vala, vb, vbnet, verilog, vhdl, vim, visualfoxpro, visualprolog, whitespace, whois, winbatch, xbasic, xml, xorg_conf, xpp, yaml, z80, zxbasic


 <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
Personal tools

Variants
Actions
Reference
Toolbox
Google AdSense