Movie Watchlist and Ratings Tracker
Design a schema tracking movies, genres, and personal ratings/watch dates, then write queries to analyze viewing habits such as favorite genres and average ratings per year. Learners practice many-to-many genre relationships, date functions, and aggregate reporting.
- Estimate
- ~7h
- Steps
- 5
- Completed by
- 0
- Proposed by
- codeseed.app
PostgreSQL · pgAdmin
Project roadmap
- 01
Design the schema
~1.5hCreate movies, genres, a movie_genres junction table, and a watch_log table with ratings and dates.
- 02
Insert sample data
~1hAdd movies across multiple genres along with a personal watch and rating history.
- 03
Compute average rating by genre
~1.5hWrite a join and GROUP BY query computing average rating per genre.
- 04
Report movies watched per month
~1.5hUse date functions to group watch history by month.
- 05
Suggest recommendations
~1.5hWrite a query surfacing highly-rated genres with few watched movies as recommendation candidates.
Resources
Ready to build this?
Get a GitHub repo and start building. Your AI reviewer checks each step as you go.
Tech stack