solvesql 레스토랑 웨이터의 팁 분석

https://solvesql.com/problems/characteristics-of-orders/

https://solvesql.com/problems/characteristics-of-orders/

 

코드부터 보여주자면 

select day , time , round(avg(tip),2) as avg_tip , round(avg(size),2) as avg_size
from tips
group by day, time
order by day, time

 

난 처음에 요일, 시간별로 알파벳으로 정렬하라고 해서 order by 에다가 case when문 잔뜩 넣었는데 아니였음 ㅋㅋㅋ;;