Gemechis10

team table

Gemechis10

-- 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 name FROM country WHERE name LIKE '%land%';

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