### 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 year has the least number of movies that was released and what is the title of the movie in that year that has the highest number of rating score of 1?

### Extra Knowledge:
least number of movies refers to MIN(movie_release_year); highest rating score refers to MAX(SUM(movie_id) where rating_score = '1')


SELECT DISTINCT T1.movie_release_year, T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_release_year = ( SELECT movie_release_year FROM movies GROUP BY movie_release_year ORDER BY COUNT(movie_id) DESC LIMIT 1 ) AND T2.rating_score = 1