Seddouki Younes younes8888

## databases-week1-exercises.sql

-- 1. What are the names of countries with population greater than 8 million?

SELECT name, population
FROM country
WHERE population>8000000;

-- 2. What are the names of countries that have “land” in their names?

SELECT name

## formula1.sql

create table Team(
id integer,
name text,
country text,
primary key (id)
);

create table Car(
id integer,

	-- 1. What are the names of countries with population greater than 8 million?

	SELECT name, population
	FROM country
	WHERE population>8000000;

	-- 2. What are the names of countries that have “land” in their names?

	SELECT name

	create table Team(
	id integer,
	name text,
	country text,
	primary key (id)
	);

	create table Car(
	id integer,