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

문제

solvesql.com

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

SQLite

내가 작성한 정답

select date(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 date(order_purchase_timestamp)
order by 1;