[SQL문제풀기] 쇼핑몰의 일일 매출액

문제

solvesql.com

https://solvesql.com/problems/olist-daily-revenue/

SQLite

내가 작성한 정답

select strftime('%Y-%m-%d',order_purchase_timestamp) dt,
        round(sum(payment_value),2) revenue_daily
from olist_orders_dataset o 
join olist_order_payments_dataset p on o.order_id = p.order_id
where order_purchase_timestamp >= '2018-01-01'
group by dt
order by 1 asc