### 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:
Which title list has not been updated for the longest period of time? State how long it has not been updated?

### Extra Knowledge:
not been updated for the longest period of time refers to MIN(list_update_timestamp_utc); how long it has not been updated refers to SUBTRACT(CURRENT_TIMESTAMP, list_update_timestamp_utc)
SELECT list_title , datetime(CURRENT_TIMESTAMP, 'localtime') - datetime(list_update_timestamp_utc) FROM lists ORDER BY list_update_timestamp_utc LIMIT 1