GKing3

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

GKing3

create table team (
	id integer auto_increment,
	name varchar(50) not null unique,
	country text not null,
	primary key (id)
);

create table car (
	id integer,
	carNumber integer not null unique,