# SELECT basics/zh

## Introducing the `world` table of countries

Summary

```SELECT population FROM world
WHERE name = 'France'
```
```SELECT population FROM world
WHERE name = 'Germany'
```

## Per Capita GDP

```SELECT name, population/area FROM world
WHERE area > 5000000
```
```SELECT name, gdp/population FROM world
WHERE area > '5000000'
```

## Scandinavia

Checking a list The word IN allows us to check if an item is in a list. The example shows the name and population for the countries 'Luxembourg', 'Mauritius' and 'Samoa'.

Show the name and the population for 'Ireland', 'Iceland' and 'Denmark'.

```SELECT name, population FROM world
WHERE name IN ('Luxembourg', 'Mauritius', 'Samoa');
```
```SELECT name, population FROM world
WHERE name IN ('Ireland', 'Iceland', 'Denmark');
```

You are ready for tutorial one:SELECT statements with WHERE.

## Just the right size

Which countries are not too small and not too big? `BETWEEN` allows range checking (range specified is inclusive of boundary values). The example below shows countries with an area of 250,000-300,000 sq. km. Modify it to show the country and the area for countries with an area between 200,000 and 250,000.

```SELECT name, area FROM world
WHERE area BETWEEN 250000 AND 300000
```

```SELECT name, area FROM world
WHERE area BETWEEN 200000 AND 250000
```

You are ready for tutorial one:SELECT statements with WHERE.

 語言: [[:{{#invoke:String|sub|SELECT basics/zh ``` |1 |Expression error: Unrecognized punctuation character "{". ``` }}|English]]

## Per Capita GDP

```SELECT name, population/area FROM world
WHERE area > 5000000
```
```SELECT name, gdp/population FROM world
WHERE area > '5000000'
```