SELECT Name, Population
FROM country
WHERE Population BETWEEN 100000000 AND 1000000000
| Name | Population |
| Bangladesh | 129,155,000 |
| Brazil | 170,115,000 |
| Indonesia | 212,107,000 |
| Japan | 126,714,000 |
| Nigeria | 111,506,000 |
| Pakistan | 156,483,000 |
| Russian Federation | 146,934,000 |
| United States | 278,357,000 |
| 使用 BETWEEN 时要给出两个值：范围的下界和上界，两个值之间用 AND 关键字分隔。BETWEEN 匹配范围内的所有值，包括给出的起止值本身。 |