SELECT from MONDE - Revision history

Bricec at 14:37, 20 December 2012

2012-12-20T14:37:26Z

Bricec at 14:16, 20 December 2012

2012-12-20T14:16:50Z

Bricec at 14:15, 20 December 2012

2012-12-20T14:15:41Z

Bricec at 14:02, 20 December 2012

2012-12-20T14:02:39Z

Bricec at 13:41, 20 December 2012

2012-12-20T13:41:37Z

Bricec at 13:40, 20 December 2012

2012-12-20T13:40:13Z

Bricec at 13:38, 20 December 2012

2012-12-20T13:38:14Z

Bricec: Created page with "

nom continent area population gdp

Afghanistan Asia
2012-12-20T13:37:38Z

Created page with "<div class="ref_section"> <table class='db_ref'> <tr><th>nom</th><th>continent</th><th>area</th> <th>population</th><th>gdp</th></tr> <tr><td>Afghanistan</td><td>Asia</td><td ..."

New page
<div class="ref_section">
<table class='db_ref'>
<tr><th>nom</th><th>continent</th><th>area</th>
<th>population</th><th>gdp</th></tr>
<tr><td>Afghanistan</td><td>Asia</td><td class="r">652230</td><td class="r">25500100</td><td class="r">20343000000</td></tr>
<tr><td>Albania</td><td>Europe</td><td class="r">28748 </td><td class="r">2831741 </td><td class="r">12960000000 </td></tr>
<tr><td>Algeria</td><td>Africa</td><td class="r">2381741 </td><td class="r">37100000 </td><td class="r">188681000000 </td></tr>
<tr><td>Andorra</td><td>Europe</td><td class="r">468</td><td class="r">78115 </td><td class="r">3712000000 </td></tr><tr>
<td>Angola</td><td>Africa</td><td class="r">1246700 </td><td class="r">20609294 </td><td class="r">100990000000 </td></tr>
<tr>
<td colspan='5'>...</td>
</tr>
</table>
</div>

==World Country Profiles==
In this tutorial you will use the SELECT command on the table <code>World</code>:

<div class='extra_space' style='width:1em; height:2.5em;'></div>

<div class="progress_panel"><div>
<div class="summary">Summary</div>
<div class="progressbarbg">
<div class="progressbar"></div>
</div>
</div></div>

==Warming up==
<div class='qu'>
[[Read_the_notes_about_this_table. |Read the notes about this table.]] Observe the result of running a simple SQL command.
<source lang='sql' class='def'>
SELECT name, continent, population FROM world
</source>

<source lang='sql' class='ans'>
SELECT name, continent, population FROM world
</source>
</div>

==Large Countries==
[[WHERE_filters |How to use WHERE to filter records.]]
<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)
<source lang='sql' class='def'>
SELECT name FROM world
WHERE population>250000000
</source>

<source lang='sql' class='ans'>
SELECT name FROM world
WHERE population>200000000
</source>
</div>

<div class='qu'>
Give the name and the per capita GDP for those countries with a population of at least 200 million.
<div title="HELP:How to calculate per capita GDP" class='hint'>
per capita GDP is the GDP divided by the population GDP/population
</div>
<source lang='sql' class='def'>
</source>

<source lang='sql' class='ans'>
SELECT name, gdp/population FROM world
WHERE population > 200000000
</source>
</div>

<div class='qu'>
Show the <code>name</code> and <code>population</code> in millions for the countries of 'South America'
Divide the population by 1000000 to get population in millions.
<source lang='sql' class='def'>
</source>

<source lang='sql' class='ans'>
SELECT name, population/1000000 FROM world
WHERE continent='South America'
</source>
</div>

<div class='qu'>
Show the <code>name</code> and <code>population</code> for 'France', 'Germany', 'Italy'
<source lang='sql' class='def'>
</source>

<source lang='sql' class='ans'>
SELECT name, population FROM world
WHERE name IN ('France','Germany','Italy')
</source>
</div>

<div class='qu'>
Identify the countries which have names including the word 'United'
<source lang='sql' class='def'>
</source>

<source lang='sql' class='ans'>
SELECT name FROM world
WHERE name LIKE '%United%'
</source>
</div>
<div>
<div class="lsclear">Clear your results</div>
<p><div class="quizlink">[[BBC QUIZ]]</div></p>
</div>
<h2>What Next</h2>
<ul>
<li>You can play a game:
[http://sqlzoo.net/~andrew/brain/bt.htm Find the duplicate]
</li>
<li>You can to continue practising the the same techniques
and gain more experience of the basic skills on the Nobel table.
[[SELECT_from_Nobel_Tutorial |The <code>WHERE</code> statement using the
<code>nobel</code> table.]]
</li>
<li>You can learn about nested statements, these are instructive and entertaining, but not essential for beginners.
[[SELECT_within_SELECT_Tutorial |Nested <code>SELECT</code> statements using the
<code>world</code> table.]]</li>
</ul>

← Older revision		Revision as of 14:37, 20 December 2012
Line 1:		Line 1:
		+	[[Main_Page/fr\|Retour à la page principale]]
		+
	<div class="ref_section">		<div class="ref_section">
	<table class='db_ref'>		<table class='db_ref'>

@@ Line 103: / Line 103: @@
 <div>
 <div class="lsclear">Effacer vos résultats</div>
-<p><div class="quizlink">[[BBC QUIZ]]</div></p>
+<p><div class="quizlink">[[QUIZ BBC]]</div></p>
 </div>
 <h2>What Next</h2>

@@ Line 28: / Line 28: @@
 ==Echauffement==
 <div class='qu'>
-[[Read_the_notes_about_this_table. |Read the notes about this table.]] Observer le résultat de cette commande SQL simple.
+[[Lire_notes_a_propose_de_cette_table. |Lire les notes à propos de cette table.]] Observer le résultat de cette commande SQL simple.
 <source lang='sql' class='def'>
 SELECT name, continent, population FROM world

@@ Line 41: / Line 41: @@
 [[WHERE_filters |How to use WHERE to filter records.]]
 <div class='qu'>
-Afficher le nom des pays qui ont une population d'au moins 200 million d'habitants. (200 million c'est 200000000, il y a 8 zéros)
+Afficher le nom des pays qui ont une population d'au moins 200 million d'habitants. (200 million c'est 200000000, il y a 8  zéros)
 <source lang='sql' class='def'>
 SELECT name FROM world
@@ Line 55: / Line 55: @@
 <div class='qu'>
-Donner le nom et le PIB par habitant pour les pays dont le nombre d'habitants est au moins 200 million.
+Afficher le nom et le PIB par habitant pour les pays dont le nombre d'habitants est au moins 200 million.
 <div title="AIDE:Comment calculer le PIB par habitant" class='hint'>
 le PIB par habitant est le PIB divisé par la population
@@ Line 69: / Line 69: @@
 <div class='qu'>
-Show the <code>name</code> and <code>population</code> in millions for the countries of 'South America'
+Afficher le nom et la population (<code>name</code> et <code>population</code>) en millions pour les pays 'South America'
-Divide the population by 1000000 to get population in millions.
+Diviser la population par 1000000 pour obtenir la population en millions.
 <source lang='sql' class='def'>
 </source>
@@ Line 81: / Line 81: @@
 <div class='qu'>
-Show the <code>name</code> and <code>population</code> for 'France', 'Germany', 'Italy'
+Afficher le nom et la population  (<code>name</code> et <code>population</code>) pour pour 'France', 'Germany', 'Italy'
 <source lang='sql' class='def'>
 </source>
@@ Line 92: / Line 92: @@
 <div class='qu'>
-Identify the countries which have names including the word 'United'
+Identifiez les pays dont les noms comprennent le mot 'United'
 <source lang='sql' class='def'>
 </source>
@@ Line 102: / Line 102: @@
 </div>
 <div>
-<div class="lsclear">Clear your results</div>
+<div class="lsclear">Effacer vos résultats</div>
 <p><div class="quizlink">[[BBC QUIZ]]</div></p>
 </div>

@@ Line 14: / Line 14: @@
 </div>
-==World Country Profiles==
+==Profile de pays==
-In this tutorial you will use the SELECT command on the table <code>World</code>:
+Dans ce tutoriel, nous utiliserons l'instruction SELECT sur la table <code>World</code>:
 <div class='extra_space' style='width:1em; height:2.5em;'></div>
 <div class="progress_panel"><div>
-    <div class="summary">Summary</div>
+    <div class="summary">Résumé</div>
     <div class="progressbarbg">
       <div class="progressbar"></div>
@@ Line 26: / Line 26: @@
 </div></div>
-==Warming up==
+==Echauffement==
 <div class='qu'>
-[[Read_the_notes_about_this_table. |Read the notes about this table.]] Observe the result of running a simple SQL command.
+[[Read_the_notes_about_this_table. |Read the notes about this table.]] Observer le résultat de cette commande SQL simple.
 <source lang='sql' class='def'>
 SELECT name, continent, population FROM world

@@ Line 1: / Line 1: @@
 <div class="ref_section">
 <table class='db_ref'>
-<tr><th>nom</th><th>continent</th><th>area</th>
+<tr><th>name</th><th>continent</th><th>area</th>
 <th>population</th><th>gdp</th></tr>
 <tr><td>Afghanistan</td><td>Asia</td><td class="r">652230</td><td class="r">25500100</td><td class="r">20343000000</td></tr>