sqlsolve1 [solvesql][SQLite] 쇼핑몰의 일일 매출액과 ARPPU https://solvesql.com/problems/daily-arppu/ https://solvesql.com/problems/daily-arppu/ solvesql.com select date(a.order_purchase_timestamp) as dt, count(distinct a.customer_id) as pu, round(sum(b.payment_value), 2) as revenue_daily, round(sum(b.payment_value)/count(distinct a.customer_id), 2) as arppu from olist_orders_dataset a join olist_order_payments_dataset b on a.order_id = b.order_id where.. 2023. 12. 6. 이전 1 다음