Tmp
Jump to navigation
Jump to search
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
DataWars: Practice Data Science/Analysis with +100 Real Life Projects