SELECT Name, Population
FROM country
WHERE
Population > 100000000 AND
Continent <> 'Asia'
| Name | Population |
| Brazil | 170,115,000 |
| Nigeria | 111,506,000 |
| Russian Federation | 146,934,000 |
| United States | 278,357,000 |
| The AND keyword is used in a WHERE clause to specify that only rows matching all the specified conditions should be retrieved. |