### Database Schema:
CREATE TABLE production_country (
	movie_id	INTEGER	NULL	DEFAULT NULL,
	country_id	INTEGER	NULL	DEFAULT NULL,
	foreign key (movie_id) references movie (movie_id),
	foreign key (country_id) references country (country_id)
);

CREATE TABLE movie_cast (
	movie_id	INTEGER	NULL	DEFAULT NULL,
	person_id	INTEGER	NULL	DEFAULT NULL,
	character_name	TEXT	NULL	DEFAULT NULL,
	gender_id	INTEGER	NULL	DEFAULT NULL,
	cast_order	INTEGER	NULL	DEFAULT NULL,
	foreign key (movie_id) references movie (movie_id),
	foreign key (person_id) references person (person_id),
	foreign key (gender_id) references gender (gender_id)
);

CREATE TABLE language_role (
	role_id	INTEGER	NOT NULL	PRIMARY KEY,
	language_role	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE genre (
	genre_id	INTEGER	NOT NULL	PRIMARY KEY,
	genre_name	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE movie_genres (
	movie_id	INTEGER	NULL	DEFAULT NULL,
	genre_id	INTEGER	NULL	DEFAULT NULL,
	foreign key (genre_id) references genre (genre_id),
	foreign key (movie_id) references movie (movie_id)
);

CREATE TABLE gender (
	gender_id	INTEGER	NOT NULL	PRIMARY KEY,
	gender	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE movie_crew (
	movie_id	INTEGER	NULL	DEFAULT NULL,
	person_id	INTEGER	NULL	DEFAULT NULL,
	department_id	INTEGER	NULL	DEFAULT NULL,
	job	TEXT	NULL	DEFAULT NULL,
	foreign key (movie_id) references movie (movie_id),
	foreign key (department_id) references department (department_id),
	foreign key (person_id) references person (person_id)
);

CREATE TABLE movie (
	movie_id	INTEGER	NOT NULL	PRIMARY KEY,
	title	TEXT	NULL	DEFAULT NULL,
	budget	INTEGER	NULL	DEFAULT NULL,
	homepage	TEXT	NULL	DEFAULT NULL,
	overview	TEXT	NULL	DEFAULT NULL,
	popularity	REAL	NULL	DEFAULT NULL,
	release_date	DATE	NULL	DEFAULT NULL,
	revenue	INTEGER	NULL	DEFAULT NULL,
	runtime	INTEGER	NULL	DEFAULT NULL,
	movie_status	TEXT	NULL	DEFAULT NULL,
	tagline	TEXT	NULL	DEFAULT NULL,
	vote_average	REAL	NULL	DEFAULT NULL,
	vote_count	INTEGER	NULL	DEFAULT NULL
);

CREATE TABLE country (
	country_id	INTEGER	NOT NULL	PRIMARY KEY,
	country_iso_code	TEXT	NULL	DEFAULT NULL,
	country_name	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE department (
	department_id	INTEGER	NOT NULL	PRIMARY KEY,
	department_name	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE keyword (
	keyword_id	INTEGER	NOT NULL	PRIMARY KEY,
	keyword_name	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE movie_company (
	movie_id	INTEGER	NULL	DEFAULT NULL,
	company_id	INTEGER	NULL	DEFAULT NULL,
	foreign key (company_id) references production_company (company_id),
	foreign key (movie_id) references movie (movie_id)
);

CREATE TABLE production_company (
	company_id	INTEGER	NOT NULL	PRIMARY KEY,
	company_name	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE movie_languages (
	movie_id	INTEGER	NULL	DEFAULT NULL,
	language_id	INTEGER	NULL	DEFAULT NULL,
	language_role_id	INTEGER	NULL	DEFAULT NULL,
	foreign key (language_role_id) references language_role (role_id),
	foreign key (movie_id) references movie (movie_id),
	foreign key (language_id) references language (language_id)
);

CREATE TABLE movie_keywords (
	movie_id	INTEGER	NULL	DEFAULT NULL,
	keyword_id	INTEGER	NULL	DEFAULT NULL,
	foreign key (movie_id) references movie (movie_id),
	foreign key (keyword_id) references keyword (keyword_id)
);

CREATE TABLE person (
	person_id	INTEGER	NOT NULL	PRIMARY KEY,
	person_name	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE language (
	language_id	INTEGER	NOT NULL	PRIMARY KEY,
	language_code	TEXT	NULL	DEFAULT NULL,
	language_name	TEXT	NULL	DEFAULT NULL
);

### User's Query:
Tell the language of the movie "C'era una volta il West".

### Extra Knowledge:
language refers to language_name; movie "C'era una volta il West" refers to title = 'C''era una volta il West'
SELECT T3.language_name FROM movie AS T1 INNER JOIN movie_languages AS T2 ON T1.movie_id = T2.movie_id INNER JOIN language AS T3 ON T2.language_id = T3.language_id WHERE T1.title LIKE 'C%era una volta il West'