Difference between revisions of "SELECT Quiz"
Line 44: | 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 | + | - <syntaxhighlight lang='sql'> SELECT name, population FROM bbc WHERE area BETWEEN 100000000 AND 200000000 </syntaxhighlight> |
− | - SELECT name, population FROM bbc WHERE population BETWEEN (100000000, 200000000) | + | - <syntaxhighlight lang='sql'> SELECT name, population FROM bbc WHERE population BETWEEN (100000000, 200000000) </syntaxhighlight> |
− | + SELECT name, population FROM bbc WHERE population BETWEEN 100000000 AND 200000000 | + | + <syntaxhighlight lang='sql'> SELECT name, population FROM bbc WHERE population BETWEEN 100000000 AND 200000000 </syntaxhighlight> |
− | - SELECT name, population FROM bbc WHERE population BETWEEN 100000000, 200000000 | + | - <syntaxhighlight lang='sql'> SELECT name, population FROM bbc WHERE population BETWEEN 100000000, 200000000 </syntaxhighlight> |
− | - SELECT population FROM bbc WHERE population BETWEEN 100000000 AND 200000000 | + | - <syntaxhighlight lang='sql'> SELECT population FROM bbc WHERE population BETWEEN 100000000 AND 200000000 </syntaxhighlight> |
− | {Pick the result you would obtain from this code: SELECT name, population FROM bbc WHERE name LIKE "Al%" | + | {Pick the result you would obtain from this code: |
+ | <syntaxhighlight lang='sql'> | ||
+ | SELECT name, population | ||
+ | FROM bbc | ||
+ | WHERE name LIKE "Al%"</syntaxhighlight> | ||
<table style='float:left'><caption>Table-A</caption> | <table style='float:left'><caption>Table-A</caption> | ||
<tr> | <tr> | ||
Line 90: | Line 94: | ||
{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%' | + | - <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name LIKE 'a%' AND name LIKE 'l%' </syntaxhighlight> |
− | - SELECT name FROM bbc WHERE name LIKE 'a%' OR name LIKE 'l%' | + | - <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name LIKE 'a%' OR name LIKE 'l%' </syntaxhighlight> |
− | - SELECT name FROM bbc WHERE name LIKE '%a' AND name LIKE '%l' | + | - <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name LIKE '%a' AND name LIKE '%l' </syntaxhighlight> |
− | - SELECT name FROM bbc WHERE name LIKE '%a' OR 'l%' | + | - <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name LIKE '%a' OR 'l%' </syntaxhighlight> |
− | + SELECT name FROM bbc WHERE name LIKE '%a' OR name LIKE '%l' | + | + <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name LIKE '%a' OR name LIKE '%l' </syntaxhighlight> |
− | {Pick the | + | {Pick the result from the query |
+ | <syntaxhighlight lang='sql'> | ||
+ | SELECT name,length(name) | ||
+ | FROM world | ||
+ | WHERE length(name)=5 and continent='Europe' | ||
+ | </syntaxhighlight> | ||
+ | <table><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><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><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><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><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="()"} | |type="()"} | ||
− | - | + | - Table-A |
− | + | + | - Table-B |
− | - | + | + Table-C |
− | - | + | - Table-D |
− | - | + | - Table-E |
− | {Pick the result you would obtain from this code: SELECT name, area * 2 FROM bbc WHERE population = 64000 | + | {Pick the result you would obtain from this code: |
+ | <syntaxhighlight lang='sql'>SELECT name, area * 2 FROM bbc WHERE population = 64000</syntaxhighlight> | ||
<table style='float:left'><caption>Table-A</caption><tr><td>Andorra</td><td>234</td></tr></table> | <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-B</caption><tr><td>Andorra</td><td>468</td></tr></table> | ||
Line 119: | Line 134: | ||
{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 | + | - <syntaxhighlight lang='sql'> SELECT name, area, population FROM bbc WHERE area < 50000 AND population < 10000000 </syntaxhighlight> |
− | - SELECT name, area, population FROM bbc WHERE area < 50000 AND population > 10000000 | + | - <syntaxhighlight lang='sql'> SELECT name, area, population FROM bbc WHERE area < 50000 AND population > 10000000 </syntaxhighlight> |
− | + SELECT name, area, population FROM bbc WHERE area > 50000 AND population < 10000000 | + | + <syntaxhighlight lang='sql'> SELECT name, area, population FROM bbc WHERE area > 50000 AND population < 10000000 </syntaxhighlight> |
− | - SELECT name, area, population FROM bbc WHERE area > 50000 AND population > 10000000 | + | - <syntaxhighlight lang='sql'> SELECT name, area, population FROM bbc WHERE area > 50000 AND population > 10000000 </syntaxhighlight> |
− | - SELECT name, area, population FROM bbc WHERE area = 50000 AND population = 10000000 | + | - <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 | {Select the code that shows the population density of China, Australia, Nigeria and France | ||
|type="()"} | |type="()"} | ||
− | - SELECT name, area/population FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia') | + | - <syntaxhighlight lang='sql'> SELECT name, area/population FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia') </syntaxhighlight> |
− | - SELECT name, area/population FROM bbc WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia') | + | - <syntaxhighlight lang='sql'> SELECT name, area/population FROM bbc WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia') </syntaxhighlight> |
− | + SELECT name, population/area FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia') | + | + <syntaxhighlight lang='sql'> SELECT name, population/area FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia') </syntaxhighlight> |
− | - SELECT name, population/area FROM bbc WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia') | + | - <syntaxhighlight lang='sql'> SELECT name, population/area FROM bbc WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia') </syntaxhighlight> |
− | - SELECT name, population FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia') | + | - <syntaxhighlight lang='sql'> SELECT name, population FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia') </syntaxhighlight> |
{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%' | {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%' |
Revision as of 10:38, 12 July 2013
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 result from the query
SELECT name,length(name)
FROM world
WHERE length(name)=5 and continent='Europe'
name | length(name) |
---|---|
Benin | 5 |
Lybia | 5 |
Egypt | 5 |
name | length(name) |
---|---|
Italy | 5 |
Egypt | 5 |
Spain | 5 |
name | length(name) |
---|---|
Italy | 5 |
Malta | 5 |
Spain | 5 |
name | length(name) |
---|---|
Italy | 5 |
France | 6 |
Spain | 5 |
name | length(name) |
---|---|
Sweden | 6 |
Norway | 6 |
Poland | 6 |
|type="()"} - Table-A - Table-B + Table-C - Table-D - Table-E
{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>