Tmp

Large Countries

How to use WHERE to filter records. 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 world
WHERE population = 64105700

SELECT name FROM world
WHERE population>200000000

Large Countries Ordered

How to use WHERE to filter records. 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 world
WHERE population = 64105700

SELECT name FROM world
WHERE population>200000000