CREATE TABLE genre ( genre_id SERIAL PRIMARY KEY, genre_name VARCHAR(50) UNIQUE NOT NULL );
CREATE INDEX idx_movie_release ON movie(release_date); CREATE INDEX idx_rating_score ON rating(score); CREATE INDEX idx_cast_name ON movie_cast(actor_id); CREATE INDEX idx_movie_title_gin ON movie USING GIN(to_tsvector('english', title)); database of movies
A database of movies is a digital collection of information about films, including their titles, directors, actors, genres, release dates, and more. These databases are often online and accessible to anyone with an internet connection, making it easy to search, browse, and explore the vast world of cinema. CREATE TABLE genre ( genre_id SERIAL PRIMARY KEY,
WITH target_user_ratings AS ( SELECT movie_id FROM rating WHERE user_id = 42 AND score >= 8 ) SELECT r.user_id, COUNT(*) AS common_likes FROM rating r JOIN target_user_ratings t ON r.movie_id = t.movie_id WHERE r.score >= 8 AND r.user_id != 42 GROUP BY r.user_id ORDER BY common_likes DESC LIMIT 10; genre_name VARCHAR(50) UNIQUE NOT NULL )