# SELECT from BBC Tutorial

Jump to: navigation, search

## BBC Country Profiles

This tutorial introduces SQL as a query language. We will be using the SELECT command on the table bbc:

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

## Warming up

Read the notes about this table. Observe the result of running a simple SQL command.

`SELECT name, region, population FROM bbc`
`SELECT name, region, population FROM bbc`

## Large Countries

Show the name for the countries that have a population of at least 200 million. (200 million is 200000000, there are eight zeros)

```SELECT name FROM bbc
WHERE population>250000000```
```SELECT name FROM bbc
WHERE population>200000000```

Give the name and the per capita GDP for those countries with a population of at least 200 million.

per capita GDP is the GDP divided by the population GDP/population

` `
```SELECT name, gdp/population FROM bbc
WHERE population > 200000000```

Show the `name` and `population` in millions for the countries of 'Middle East' Divide the population by 1000000 to get population in millions.

` `
```SELECT name, population/1000000 FROM bbc
WHERE region='Middle East'```

Show the `name` and `population` for 'France', 'Germany', 'Italy'

` `
```SELECT name, population FROM bbc
WHERE name IN ('France','Germany','Italy')```

Identify the countries which have names including the word 'United'

` `
```SELECT name FROM bbc
WHERE name LIKE '%United%'```

## What Next

• You can play a game: Find the duplicate
• You can to continue practicing the the same techniques and gain more experience of the basic skills on the Nobel table. [[SELECT_from_Nobel_Tutorial |The `WHERE` statement using the `nobel` table.]
• You can learn about nested statements, these are instructive and entertaining, but rarely useful. [[SELECT_within_SELECT_Tutorial |Nested `SELECT` statements using the `bbc` table.
• ]