### Database Schema:
CREATE TABLE lists_users (
	user_id	INTEGER	NOT NULL	PRIMARY KEY,
	list_id	INTEGER	NOT NULL	PRIMARY KEY,
	list_update_date_utc	TEXT	NULL,
	list_creation_date_utc	TEXT	NULL,
	user_trialist	INTEGER	NULL,
	user_subscriber	INTEGER	NULL,
	user_avatar_image_url	TEXT	NULL,
	user_cover_image_url	TEXT	NULL,
	user_eligible_for_trial	TEXT	NULL,
	user_has_payment_method	TEXT	NULL,
	foreign key (list_id) references lists (list_id),
	foreign key (user_id) references lists (user_id)
);

CREATE TABLE ratings_users (
	user_id	INTEGER	NULL,
	rating_date_utc	TEXT	NULL,
	user_trialist	INTEGER	NULL,
	user_subscriber	INTEGER	NULL,
	user_avatar_image_url	TEXT	NULL,
	user_cover_image_url	TEXT	NULL,
	user_eligible_for_trial	INTEGER	NULL,
	user_has_payment_method	INTEGER	NULL,
	foreign key (user_id) references lists_users (user_id)
);

CREATE TABLE movies (
	movie_id	INTEGER	NOT NULL	PRIMARY KEY,
	movie_title	TEXT	NULL,
	movie_release_year	INTEGER	NULL,
	movie_url	TEXT	NULL,
	movie_title_language	TEXT	NULL,
	movie_popularity	INTEGER	NULL,
	movie_image_url	TEXT	NULL,
	director_id	TEXT	NULL,
	director_name	TEXT	NULL,
	director_url	TEXT	NULL
);

CREATE TABLE lists (
	user_id	INTEGER	NULL,
	list_id	INTEGER	NOT NULL	PRIMARY KEY,
	list_title	TEXT	NULL,
	list_movie_number	INTEGER	NULL,
	list_update_timestamp_utc	TEXT	NULL,
	list_creation_timestamp_utc	TEXT	NULL,
	list_followers	INTEGER	NULL,
	list_url	TEXT	NULL,
	list_comments	INTEGER	NULL,
	list_description	TEXT	NULL,
	list_cover_image_url	TEXT	NULL,
	list_first_image_url	TEXT	NULL,
	list_second_image_url	TEXT	NULL,
	list_third_image_url	TEXT	NULL,
	foreign key (user_id) references lists_users (user_id)
);

CREATE TABLE ratings (
	movie_id	INTEGER	NULL,
	rating_id	INTEGER	NULL,
	rating_url	TEXT	NULL,
	rating_score	INTEGER	NULL,
	rating_timestamp_utc	TEXT	NULL,
	critic	TEXT	NULL,
	critic_likes	INTEGER	NULL,
	critic_comments	INTEGER	NULL,
	user_id	INTEGER	NULL,
	user_trialist	INTEGER	NULL,
	user_subscriber	INTEGER	NULL,
	user_eligible_for_trial	INTEGER	NULL,
	user_has_payment_method	INTEGER	NULL,
	foreign key (movie_id) references movies (movie_id),
	foreign key (user_id) references lists_users (user_id),
	foreign key (rating_id) references ratings (rating_id),
	foreign key (user_id) references ratings_users (user_id)
);

### User's Query:
How many movie lists were still updated 10 years after it was created?

### Extra Knowledge:
updated 10 years after it was created refers to list_update_timestamp_utc > (list_creation_timestamp_utc+10);
SELECT COUNT(*) FROM lists WHERE SUBSTR(list_update_timestamp_utc, 1, 4) - SUBSTR(list_creation_timestamp_utc, 1, 4) > 10