amirabayoumi

-- 1. What are the names of countries with population greater than 8 million?
SELECT Name 
FROM country
WHERE Population > 8000000;

-- 2. What are the names of countries that have “land” in their names?
SELECT * from country WHERE name like '%land';

-- 3. What are the names of the cities with population in between 500,000 and 1 million?
SELECT * FROM city WHERE population between 500000 and 1000000;