Difference between revisions of "BBC QUIZ"
From SQLZOO
| Line 1: | Line 1: | ||
BBC QUIZ | BBC QUIZ | ||
<quiz shuffle=none display=simple> | <quiz shuffle=none display=simple> | ||
| − | { | + | {Select the code which gives the name of countries beginning with C |
|type="()"} | |type="()"} | ||
- SELECT name FROM bbc WHERE name BEGIN with C | - SELECT name FROM bbc WHERE name BEGIN with C | ||
| Line 9: | Line 9: | ||
+ SELECT name FROM bbc WHERE name LIKE 'C%' | + SELECT name FROM bbc WHERE name LIKE 'C%' | ||
| − | { | + | {Select the code which shows just the population of United Kingdom? |
|type="()"} | |type="()"} | ||
- SELECT name FROM bbc WHERE name Like 'United%' | - SELECT name FROM bbc WHERE name Like 'United%' | ||
| Line 18: | Line 18: | ||
| − | { | + | {Select the answer which shows the problem with this SQL code:SELECT name FROM "bbc" WHERE population > '2000000' |
|type="()"} | |type="()"} | ||
- Apostrophes should be used around 'bbc' instead of speech marks | - Apostrophes should be used around 'bbc' instead of speech marks | ||
| Line 24: | Line 24: | ||
+ There are speech marks surrounding "bbc" | + There are speech marks surrounding "bbc" | ||
- There are speech marks surrounding "bbc" and there is apostrophes surrounding '2000000' | - There are speech marks surrounding "bbc" and there is apostrophes surrounding '2000000' | ||
| − | - | + | - The use of a WHERE function is incorrect |
| − | { | + | {Select the code which would reveal the name and population of countries in Europe, North America and South America |
|type="()"} | |type="()"} | ||
- SELECT name FROM bbc WHERE region IN ('Europe', 'North America', 'South America') | - SELECT name FROM bbc WHERE region IN ('Europe', 'North America', 'South America') | ||
| Line 34: | Line 34: | ||
- SELECT population FROM bbc WHERE region IN ('Europe', 'North America', 'South America') | - SELECT population FROM bbc WHERE region IN ('Europe', 'North America', 'South America') | ||
| − | { | + | {Select the code which would give two rows |
|type="()"} | |type="()"} | ||
| − | - SELECT name FROM bbc WHERE name = 'United Kingdom | + | - SELECT name FROM bbc WHERE name = 'United Kingdom' |
| − | + | + SELECT name FROM bbc WHERE name = 'United Kingdom' or name = 'Algeria' | |
| − | + | - SELECT name FROM bbc WHERE name EITHER ('United Kingdom', 'Algeria') | |
- SELECT name FROM bbc WHERE name IN ('United Kingdom', 'Algeria') | - SELECT name FROM bbc WHERE name IN ('United Kingdom', 'Algeria') | ||
| − | - | + | - SELECT name FROM WHERE name IS 'Scotland' |
</quiz> | </quiz> | ||
[[Category:Quizzes]] | [[Category:Quizzes]] | ||
Revision as of 09:17, 23 July 2012
BBC QUIZ
