SELECT *, SUM(downloads) OVER(PARTITION BY genre ORDER BY genre, name) AS genre_running_total FROM article_movies;