SELECT Quiz

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
...

1. Select the code which shows the countries with a 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 name, population FROM bbc WHERE population BETWEEN 100000000 AND 200000000
	SELECT name, population FROM bbc WHERE area BETWEEN 100000000 AND 200000000
	SELECT population FROM bbc WHERE population BETWEEN 100000000 AND 200000000

2. Select the code which shows the countries that end in A or 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 name LIKE '%l'
	SELECT name FROM bbc WHERE name LIKE 'a%' OR name LIKE 'l%'

3. Pick the code which shows the total population of Scandinavia (Denmark, Finland, Sweden and Norway)

	SELECT SUM(population) FROM bbc WHERE name IN ('Denmark', 'Norway', 'Finland','Sweden')
	SELECT 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')

4. 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

5. Select the code that would show the countries with an area larger than 50000 and a population smaller than 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 name, area, population FROM bbc WHERE area < 50000 AND population > 10000000

6. Select the code that shows the population density of China, Australia, Nigeria and France

	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')

7. 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
Angola	Africa

	(Algeria, Middle East), 32900000, (Angola, Africa), 14500000
	Algeria, 32900000, Angola, 14500000
	AlgeriaMiddle East, 32900000, AngolaAfrica, 14500000
	AngolaAfrica, 14500000[File:test.gif]
	Algeria Middle East Angola Africa

Your score is 0 / 0

Algeria	Middle East
Angola	Africa