[SQL문제풀기 - Advent of SQL 2025 🎅] 매출이 높은 배우 찾기

silver

Dec 12, 2025

[SQL문제풀기 - Advent of SQL 2025 🎅] 매출이 높은 배우 찾기

Contents

문제 내가 작성한 정답

문제

solvesql.com

https://solvesql.com/problems/top-revenue-actors/

내가 작성한 정답

: t.first_name, t.last_name는 unique가 아니라서 actor_id로 group by 해야한다

MySQL, SQLite, PostgreSQL


select t.first_name, t.last_name, a.total_revenue
from (select a.actor_id, sum(p.amount) total_revenue
      from rental r 
      join inventory i on r.inventory_id = i.inventory_id
      join payment p on r.rental_id = p.rental_id
      join film_actor a on i.film_id = a.film_id
      group by a.actor_id
      order by 2 desc
      limit 5) a
join actor t on a.actor_id = t.actor_id
order by 3 desc;