Skip to content

Instantly share code, notes, and snippets.

-- 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%';
Entities and attributes
Entities and attributes
Entities and attributes