SELECT Name, Population
FROM country
WHERE
(Population > 100000000 OR Population < 2000) AND
Continent <> 'Asia' AND
Population > 0
| Name | Population |
| Brazil | 170,115,000 |
| Cocos (Keeling) Islands | 600 |
| Nigeria | 111,506,000 |
| Pitcairn | 50 |
| Russian Federation | 146,934,000 |
| United States | 278,357,000 |
| Holy See (Vatican City State) | 1000 |
| SQL 先处理 AND，再处理 OR。因此示例用括号把相关的条件明确地分组。 |