레스토랑 요일 별 구매금액 Top 3 영수증 : solvesql

난이도 : 4 / 정답률 65.93%

answer

SELECT  day, time, sex, total_bill
FROM  (
  SELECT  day, total_bill, sex, time,
          RANK() OVER(PARTITION BY day ORDER BY total_bill DESC) as rnk
  FROM    tips
  ) as bill
WHERE   rnk IN (1,2,3)