Difference between revisions of "SELECT Quiz"
(16 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
SELECT quiz | SELECT quiz | ||
− | |||
<div class="ref_section"> | <div class="ref_section"> | ||
<table class='db_ref'><tr> | <table class='db_ref'><tr> | ||
Line 45: | Line 44: | ||
{Select the code which shows the countries with a population between 100000000 and 200000000 | {Select the code which shows the countries with a population between 100000000 and 200000000 | ||
|type="()"} | |type="()"} | ||
+ | - SELECT name, population FROM bbc WHERE area BETWEEN 100000000 AND 200000000 | ||
- SELECT name, population FROM bbc WHERE population BETWEEN (100000000, 200000000) | - SELECT name, population FROM bbc WHERE population BETWEEN (100000000, 200000000) | ||
+ | + SELECT name, population FROM bbc WHERE population BETWEEN 100000000 AND 200000000 | ||
- SELECT name, population FROM bbc WHERE population BETWEEN 100000000, 200000000 | - SELECT name, population FROM bbc WHERE population BETWEEN 100000000, 200000000 | ||
− | |||
− | |||
- SELECT population FROM bbc WHERE population BETWEEN 100000000 AND 200000000 | - SELECT population FROM bbc WHERE population BETWEEN 100000000 AND 200000000 | ||
+ | |||
+ | {Pick the result you would obtain from this code: SELECT name, population FROM bbc WHERE name LIKE "Al%" | ||
+ | <table style='float:left'><caption>Table-A</caption> | ||
+ | <tr> | ||
+ | <td>Albania</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>Algeria</td></tr></table> | ||
+ | <table style='float:left'><caption>Table-B</caption> | ||
+ | <tr> | ||
+ | <td>%bania</td> | ||
+ | <td>3200000</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>%geria</td> | ||
+ | <td>32900000</td></tr></table> | ||
+ | <table style='float:left'><caption>Table-C</caption><tr> | ||
+ | <td>Al</td> | ||
+ | <td>0 </td></tr></table> | ||
+ | <table style='float:left'><caption>Table-D</caption><tr> | ||
+ | <td>Albania</td> | ||
+ | <td>3200000</td></tr></table> | ||
+ | <table style='float:left'><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 | {Select the code which shows the countries that end in A or L | ||
|type="()"} | |type="()"} | ||
+ | - SELECT name FROM bbc WHERE name LIKE 'a%' AND name LIKE 'l%' | ||
+ | - SELECT name FROM bbc WHERE name LIKE 'a%' OR name LIKE 'l%' | ||
- SELECT name FROM bbc WHERE name LIKE '%a' AND name LIKE '%l' | - SELECT name FROM bbc WHERE name LIKE '%a' AND name LIKE '%l' | ||
− | |||
- SELECT name FROM bbc WHERE name LIKE '%a' OR 'l%' | - SELECT name FROM bbc WHERE name LIKE '%a' OR 'l%' | ||
+ SELECT name FROM bbc WHERE name LIKE '%a' OR name LIKE '%l' | + SELECT name FROM bbc WHERE name LIKE '%a' OR name LIKE '%l' | ||
− | |||
{Pick the code which shows the total population of Scandinavia (Denmark, Finland, Sweden and Norway) | {Pick the code which shows the total population of Scandinavia (Denmark, Finland, Sweden and Norway) | ||
|type="()"} | |type="()"} | ||
+ | - SELECT population FROM bbc WHERE name IN ('Denmark', 'Norway', 'Finland','Sweden') | ||
+ SELECT SUM(population) FROM bbc WHERE name IN ('Denmark', 'Norway', 'Finland','Sweden') | + SELECT SUM(population) FROM bbc WHERE name IN ('Denmark', 'Norway', 'Finland','Sweden') | ||
− | |||
- SELECT SUM(population) FROM bbc WHERE name IN 'Scandinavia' | - SELECT SUM(population) FROM bbc WHERE name IN 'Scandinavia' | ||
- SELECT SUM(population) FROM bbc WHERE name LIKE ('Denmark', 'Norway', 'Finland','Sweden') | - SELECT SUM(population) FROM bbc WHERE name LIKE ('Denmark', 'Norway', 'Finland','Sweden') | ||
- SELECT TOTAL(population) FROM bbc WHERE name IN ('Denmark', 'Norway', 'Finland','Sweden') | - SELECT TOTAL(population) FROM bbc WHERE name IN ('Denmark', 'Norway', 'Finland','Sweden') | ||
+ | |||
+ | {Pick the result you would obtain from this code: SELECT name, area * 2 FROM bbc WHERE population = 64000 | ||
+ | <table style='float:left'><caption>Table-A</caption><tr><td>Andorra</td><td>234</td></tr></table> | ||
+ | <table style='float:left'><caption>Table-B</caption><tr><td>Andorra</td><td>468</td></tr></table> | ||
+ | <table style='float:left'><caption>Table-C</caption><tr><td>Andorra</td><td>936 </td></tr></table> | ||
+ | <table style='float:left'><caption>Table-D</caption><tr><td>Andorra</td><td>4680</td></tr></table> | ||
+ | <table style='float:left'><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 | {Select the code that would show the countries with an area larger than 50000 and a population smaller than 10000000 | ||
|type="()"} | |type="()"} | ||
+ | - SELECT name, area, population FROM bbc WHERE area < 50000 AND population < 10000000 | ||
+ | - SELECT name, area, population FROM bbc WHERE area < 50000 AND population > 10000000 | ||
+ SELECT name, area, population FROM bbc WHERE area > 50000 AND population < 10000000 | + SELECT name, area, population FROM bbc WHERE area > 50000 AND population < 10000000 | ||
− | - SELECT name, area, population FROM bbc WHERE area | + | - SELECT name, area, population FROM bbc WHERE area > 50000 AND population > 10000000 |
- SELECT name, area, population FROM bbc WHERE area = 50000 AND population = 10000000 | - SELECT name, area, population FROM bbc WHERE area = 50000 AND population = 10000000 | ||
− | |||
− | |||
{Select the code that shows the population density of China, Australia, Nigeria and France | {Select the code that shows the population density of China, Australia, Nigeria and France | ||
Line 82: | Line 132: | ||
- SELECT name, population/area FROM bbc WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia') | - SELECT name, population/area FROM bbc WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia') | ||
- SELECT name, population FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia') | - SELECT name, population FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia') | ||
+ | |||
+ | {Pick the result that would be obtained from this code: SELECT CONCAT(name,region), population FROM bbc WHERE region IN ('Africa','Middle East') AND name LIKE 'A%' | ||
+ | <table style='float:left'><caption>Table-A</caption><tr><td>(Algeria, Middle East)</td><td>32900000</td></tr><tr><td>(Angola, Africa)</td><td>14500000</td></tr></table> | ||
+ | <table style='float:left'><caption>Table-B</caption><tr><td>Algeria</td><td>32900000</td></tr><tr><td>Angola</td><td>14500000</td></tr></table> | ||
+ | <table style='float:left'><caption>Table-C</caption><tr><td>AlgeriaMiddle East</td><td>32900000</td></tr><tr><td>AngolaAfrica</td><td>14500000</td></tr></table> | ||
+ | <table style='float:left'><caption>Table-D</caption><tr><td>AngolaAfrica</td><td> 14500000</td></tr></table> | ||
+ | <table style='float:left'><caption>Table-E</caption><tr><td>Algeria</td><td>Middle East</td></tr><tr><td>Angola</td><td>Africa</td></tr></table> | ||
+ | |type="()"} | ||
+ | - Table-A | ||
+ | - Table-B | ||
+ | + Table-C | ||
+ | - Table-D | ||
+ | - Table-E | ||
+ | |||
</quiz> | </quiz> | ||
[[Category:Quizzes]] | [[Category:Quizzes]] |
Revision as of 13:38, 15 August 2012
SELECT quiz
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 shows the countries with a population between 100000000 and 200000000 |type="()"} - SELECT name, population FROM bbc WHERE area BETWEEN 100000000 AND 200000000 - SELECT name, population FROM bbc WHERE population BETWEEN (100000000, 200000000) + SELECT name, population FROM bbc WHERE population BETWEEN 100000000 AND 200000000 - SELECT name, population FROM bbc WHERE population BETWEEN 100000000, 200000000 - SELECT population FROM bbc WHERE population BETWEEN 100000000 AND 200000000
{Pick the result you would obtain from this code: SELECT name, population FROM bbc WHERE name LIKE "Al%"
Albania |
Algeria |
%bania | 3200000 |
%geria | 32900000 |
Al | 0 |
Albania | 3200000 |
Albania | 3200000 |
Algeria | 32900000 |
|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="()"} - SELECT name FROM bbc WHERE name LIKE 'a%' AND name LIKE 'l%' - SELECT name FROM bbc WHERE name LIKE 'a%' OR name LIKE 'l%' - SELECT name FROM bbc WHERE name LIKE '%a' AND name LIKE '%l' - SELECT name FROM bbc WHERE name LIKE '%a' OR 'l%' + SELECT name FROM bbc WHERE name LIKE '%a' OR name LIKE '%l'
{Pick the code which shows the total population of Scandinavia (Denmark, Finland, Sweden and Norway) |type="()"} - SELECT population FROM bbc WHERE name IN ('Denmark', 'Norway', 'Finland','Sweden') + SELECT SUM(population) FROM bbc WHERE name IN ('Denmark', 'Norway', 'Finland','Sweden') - SELECT SUM(population) FROM bbc WHERE name IN 'Scandinavia' - SELECT SUM(population) FROM bbc WHERE name LIKE ('Denmark', 'Norway', 'Finland','Sweden') - SELECT TOTAL(population) FROM bbc WHERE name IN ('Denmark', 'Norway', 'Finland','Sweden')
{Pick the result you would obtain from this code: SELECT name, area * 2 FROM bbc WHERE population = 64000
Andorra | 234 |
Andorra | 468 |
Andorra | 936 |
Andorra | 4680 |
Andorra | 936 |
Albania | 57456 |
|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="()"} - SELECT name, area, population FROM bbc WHERE area < 50000 AND population < 10000000 - SELECT name, area, population FROM bbc WHERE area < 50000 AND population > 10000000 + SELECT name, area, population FROM bbc WHERE area > 50000 AND population < 10000000 - SELECT name, area, population FROM bbc WHERE area > 50000 AND population > 10000000 - SELECT name, area, population FROM bbc WHERE area = 50000 AND population = 10000000
{Select the code that shows the population density of China, Australia, Nigeria and France |type="()"} - SELECT name, area/population FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia') - SELECT name, area/population FROM bbc WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia') + SELECT name, population/area FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia') - SELECT name, population/area FROM bbc WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia') - SELECT name, population FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia')
{Pick the result that would be obtained from this code: SELECT CONCAT(name,region), population FROM bbc WHERE region IN ('Africa','Middle East') AND name LIKE 'A%'
(Algeria, Middle East) | 32900000 |
(Angola, Africa) | 14500000 |
Algeria | 32900000 |
Angola | 14500000 |
AlgeriaMiddle East | 32900000 |
AngolaAfrica | 14500000 |
AngolaAfrica | 14500000 |
Algeria | Middle East |
Angola | Africa |
|type="()"} - Table-A - Table-B + Table-C - Table-D - Table-E
</quiz>