BBC QUIZ

world

name	continent	area	population	gdp
Afghanistan	South Asia	652225	26000000
Albania	Europe	28728	3200000	6656000000
Algeria	Middle East	2400000	32900000	75012000000
Andorra	Europe	468	64000
Brazil	South America	8550000	182800000	564852000000
Colombia	South America	1140000	45600000
Nauru	Asia-Pacific	21	9900
Uzbekistan	Central Asia	447000	26000000
...

Select the code which gives the name of countries beginning with U

SELECT name  FROM world  WHERE name  BEGIN with U 

SELECT name  FROM world  WHERE name LIKE '%U' 

SELECT name  FROM world  WHERE name LIKE '%u%' 

SELECT name  FROM world  WHERE name LIKE U 

SELECT name  FROM world  WHERE name LIKE 'U%' 

Select the code which shows just the population of United Kingdom?

SELECT population  FROM 'United Kingdom' 

SELECT name  FROM world  WHERE population = 'United Kingdom' 

SELECT FROM world  WHERE population IN 'United Kingdom' 

SELECT population  FROM world  WHERE name = 'United Kingdom' 

SELECT population  FROM world  WHERE 'United Kingdom' IN name 

Select the answer which shows the problem with this SQL code - the intended result should be the continent of France:

 SELECT continent   FROM world   WHERE 'name' = 'France' 

continent should be 'continent'

'name' should be name

'France' should be "France"

'France' should be France

= should be IN

Select the result that would be obtained from the following code:

 SELECT name, population / 10   FROM world   WHERE population < 10000 

Andorra	6400
Nauru	990

Andorra	64000
Nauru	9900

Nauru

99

Nauru

990

Nauru

9900

Select the code which would reveal the name and population of countries in Europe and Asia

SELECT name  FROM world   WHERE continent IN ('Europe', 'Asia') 

SELECT name, population  FROM world  WHERE continent IN ('Europe', 'Asia') 

SELECT name, population  FROM world  WHERE name IN (Europe Asia) 

SELECT name, population  FROM world  WHERE name IS ('Europe', 'Asia') 

SELECT name, population  FROM world  WHERE continent = ('Europe', 'Asia') 

Select the code which would give two rows

SELECT name FROM world  WHERE name = 'Cuba' 

SELECT name FROM world  WHERE name = 'Cuba'  AND name = 'Togo' 

SELECT name FROM world  WHERE name EITHER ('Cuba', 'Togo') 

SELECT name FROM world  WHERE name IN ('Cuba', 'Togo') 

SELECT name FROM WHERE name IS 'Mali' 

Select the result that would be obtained from this code:

SELECT name FROM world  WHERE continent = 'South America'  AND population > 40000000 

Afghanistan

Brazil

Colombia

Brazil

Brazil

Colombia

Brazil	South America
Colombia	South America

Brazil	182800000
Colombia	45600000