Category "eager-loading"

Getting an average rating of a TV show using average ratings of its seasons from ratings table (Laravel 9)

I have 3 tables: shows, seasons and ratings. I would like to get average ratings of specific seasons and then make an average of this for every show and sort th