Tmp
From SQLZoo
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