BBC QUIZ

world table

Link

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

   SELECT name
     FROM world
    WHERE name LIKE 'U%'

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

   SELECT population
     FROM world
    WHERE name = 'United Kingdom'

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

'name' should be name

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

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

Nauru 990

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

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

6. Select the code which would give two rows

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

7. Select the result that would be obtained from this code:

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

Brazil Colombia