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

문제

solvesql.com

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

SQLite

내가 작성한 정답

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