SELECT Quiz

From SQLZOO
Revision as of 09:03, 18 April 2015 by Andr3w (talk | contribs)
Jump to: navigation, search

Some questions concerning basic SQL statements

name region area population gdp
Afghanistan South Asia 652225 26000000
Albania Europe 28728 3200000 6656000000
Algeria Middle East 2400000 32900000 75012000000
Andorra Europe 468 64000
...

<quiz shuffle=none display=simple> {Select the code which produces this table <table class="sqlmine"><tr><th>name</th><th>population</th></tr><tr><td>Bahrain</td><td class="r">1234571</td></tr><tr><td>Swaziland</td><td class="r">1220000</td></tr><tr><td>Timor-Leste</td><td class="r">1066409</td></tr></table> |type="()"} - <syntaxhighlight lang='sql'>FROM world SELECT name, population BETWEEN 1000000 AND 1250000</syntaxhighlight> - <syntaxhighlight lang='sql'>FROM name, population WHERE population BETWEEN 1000000 AND 1250000 SELECT world</syntaxhighlight> + <syntaxhighlight lang='sql'>SELECT name, population FROM world WHERE population BETWEEN 1000000 AND 1250000</syntaxhighlight> - <syntaxhighlight lang='sql'>SELECT population BETWEEN 1000000 AND 1250000 FROM world</syntaxhighlight> - <syntaxhighlight lang='sql'>WHERE population BETWEEN 1000000 AND 1250000 SELECT name, population FROM world</syntaxhighlight> {Pick the result you would obtain from this code: <syntaxhighlight lang='sql'> SELECT name, population FROM bbc WHERE name LIKE "Al%"</syntaxhighlight> <table class='distractor'><caption>Table-A</caption> <tr> <td>Albania</td> </tr> <tr> <td>Algeria</td></tr></table> <table class='distractor'><caption>Table-B</caption> <tr> <td>%bania</td> <td>3200000</td> </tr> <tr> <td>%geria</td> <td>32900000</td></tr></table> <table class='distractor'><caption>Table-C</caption><tr> <td>Al</td> <td>0 </td></tr></table> <table class='distractor'><caption>Table-D</caption><tr> <td>Albania</td> <td>3200000</td></tr></table> <table class='distractor'><caption>Table-E</caption> <tr> <td>Albania</td> <td>3200000</td> </tr> <tr> <td>Algeria</td> <td>32900000</td> </tr> </table> |type="()"} - Table-A - Table-B - Table-C - Table-D + Table-E {Select the code which shows the countries that end in A or L |type="()"} - <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name LIKE 'a%' AND name LIKE 'l%' </syntaxhighlight> - <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name LIKE 'a%' OR name LIKE 'l%' </syntaxhighlight> - <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name LIKE '%a' AND name LIKE '%l' </syntaxhighlight> - <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name LIKE '%a' OR 'l%' </syntaxhighlight> + <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name LIKE '%a' OR name LIKE '%l' </syntaxhighlight> {Pick the result from the query <syntaxhighlight lang='sql'> SELECT name,length(name) FROM world WHERE length(name)=5 and region='Europe' </syntaxhighlight> <table class='distractor'><caption>Table-A</caption><tr><th>name</th><th>length(name)</th></tr><tr><td>Benin</td><td class="r">5</td></tr><tr><td>Lybia</td><td class="r">5</td></tr><tr><td>Egypt</td><td class="r">5</td></tr></table> <table class='distractor'><caption>Table-B</caption><tr><th>name</th><th>length(name)</th></tr><tr><td>Italy</td><td class="r">5</td></tr><tr><td>Egypt</td><td class="r">5</td></tr><tr><td>Spain</td><td class="r">5</td></tr></table> <table class='distractor'><caption>Table-C</caption><tr><th>name</th><th>length(name)</th></tr><tr><td>Italy</td><td class="r">5</td></tr><tr><td>Malta</td><td class="r">5</td></tr><tr><td>Spain</td><td class="r">5</td></tr></table> <table class='distractor'><caption>Table-D</caption><tr><th>name</th><th>length(name)</th></tr><tr><td>Italy</td><td class="r">5</td></tr><tr><td>France</td><td class="r">6</td></tr><tr><td>Spain</td><td class="r">5</td></tr></table> <table class='distractor'><caption>Table-E</caption><tr><th>name</th><th>length(name)</th></tr><tr><td>Sweden</td><td class="r">6</td></tr><tr><td>Norway</td><td class="r">6</td></tr><tr><td>Poland</td><td class="r">6</td></tr></table> |type="()"} - Table-A - Table-B + Table-C - Table-D - Table-E {Pick the result you would obtain from this code: <syntaxhighlight lang='sql'>SELECT name, area * 2 FROM bbc WHERE population = 64000</syntaxhighlight> <table class='distractor'><caption>Table-A</caption><tr><td>Andorra</td><td>234</td></tr></table> <table class='distractor'><caption>Table-B</caption><tr><td>Andorra</td><td>468</td></tr></table> <table class='distractor'><caption>Table-C</caption><tr><td>Andorra</td><td>936 </td></tr></table> <table class='distractor'><caption>Table-D</caption><tr><td>Andorra</td><td>4680</td></tr></table> <table class='distractor'><caption>Table-E</caption><tr><td>Andorra</td><td>936</td></tr><tr><td>Albania</td><td>57456</td></tr></table> |type="()"} - Table-A - Table-B + Table-C - Table-D - Table-E {Select the code that would show the countries with an area larger than 50000 and a population smaller than 10000000 |type="()"} - <syntaxhighlight lang='sql'> SELECT name, area, population FROM bbc WHERE area < 50000 AND population < 10000000 </syntaxhighlight> - <syntaxhighlight lang='sql'> SELECT name, area, population FROM bbc WHERE area < 50000 AND population > 10000000 </syntaxhighlight> + <syntaxhighlight lang='sql'> SELECT name, area, population FROM bbc WHERE area > 50000 AND population < 10000000 </syntaxhighlight> - <syntaxhighlight lang='sql'> SELECT name, area, population FROM bbc WHERE area > 50000 AND population > 10000000 </syntaxhighlight> - <syntaxhighlight lang='sql'> SELECT name, area, population FROM bbc WHERE area = 50000 AND population = 10000000 </syntaxhighlight> {Select the code that shows the population density of China, Australia, Nigeria and France |type="()"} - <syntaxhighlight lang='sql'> SELECT name, area/population FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia') </syntaxhighlight> - <syntaxhighlight lang='sql'> SELECT name, area/population FROM bbc WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia') </syntaxhighlight> + <syntaxhighlight lang='sql'> SELECT name, population/area FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia') </syntaxhighlight> - <syntaxhighlight lang='sql'> SELECT name, population/area FROM bbc WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia') </syntaxhighlight> - <syntaxhighlight lang='sql'> SELECT name, population FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia') </syntaxhighlight> </quiz>