10. Django annotated queries for Top250 films
New Year's Day, new Django upload! Continuing the year as we left off last year!
In this lesson, we look at creating annotated queries. This is another way of aggregating results as we did in lesson 8.
In this video, even though I show how to add 2 calculations to the annotate query, it's not actually used. Instead, I added another model method to work out how many votes a film has had on the film detail pages.
Follow the project using my notion notebook https://www.notion.so/bitfez/Build-IM...
Download the progress on GitHub https://github.com/bitFez/build_imdb_...
00:00 Intro
02:10 Writing the function for the Top 250 movies
03:26 Adding the annotation query to the function
07:21 replacing the way the average is called on the list pages
09:10 Adding the Rotten 250!
13:34 Adding the number of votes to the annotation query
14:32 Adding a model method for votes count