hitomipupil

CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(50),
lastname VARCHAR(50),
username VARCHAR(50),
pass VARCHAR(50)
);

CREATE TABLE schools (
id INT AUTO_INCREMENT PRIMARY KEY,

hitomipupil

CREATE TABLE Team (
id INTEGER NOT NULL,
name TEXT NOT NULL,
country TEXT,
PRIMARY KEY (id)
);

CREATE TABLE Car (
carNumber INTEGER,
wieght INTEGER,

hitomipupil

-- 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%';