[SQL문제풀기] 레스토랑 요일 별 구매금액 Top 3 영수증

문제

solvesql.com

https://solvesql.com/problems/top-3-bill/

SQLite

내가 작성한 정답

select day, time, sex, total_bill
from (select day,
            row_number() over (partition by day order by total_bill desc) ranking
            ,time, sex, total_bill
      from tips)
where ranking in (1,2,3)