-- Type your code below: SELECT name, SUM(total_votes) AS totalVotes, COUNT(rm.movie_id) AS movieCount, avg_rating, DENSE_RANK() OVER(ORDER BY avg_rating DESC) AS actressRank FROM names AS n INNER JOIN role_mapping AS rm ON n.id = rm.name_id INNER JOIN ratings AS r ON r.movie_id = rm.movie_id INNER JOIN genre AS g ON r.movie_id = g.movie_id WHERE category = 'actress' AND avg_rating > 8 AND genre = 'drama' GROUP BY name LIMIT 3