[SQL테스트]쇼핑몰의 일일 매출액과 ARPPU

문제

https://solvesql.com/problems/daily-arppu/

풀이

SELECT 
  DATE(order_purchase_timestamp) AS dt,
  COUNT(DISTINCT oopd.order_id) AS pu,
  ROUND(SUM(payment_value),2) AS revenue_daily,
  ROUND((SUM(payment_value)/COUNT(DISTINCT oopd.order_id)),2) AS arppu

FROM olist_orders_dataset ood
  INNER JOIN olist_order_payments_dataset oopd
  ON ood.order_id = oopd.order_id

WHERE 1=1
AND dt >= '2018-01-01'
GROUP BY dt
ORDER BY dt

후기

아주 쉬운 문제였다.
다만 나같은 경우 날짜를 주문 승인 시각으로 착각해서 좀 해맴...