I'm trying to display a list of authors with their respective total view count across all of their posts. I understand this requires SQL queries along the following lines:
1. Get all the posts associated with Authors.
2. Sum the total views of those posts.
3. Output the list of authors with total combined views in descending order.
Any help is greatly appreciated.