[SQL문제풀기] 버뮤다 삼각지대에 들어가버린 택배

문제

solvesql.com

https://solvesql.com/problems/shipment-in-bermuda/

SQLite

내가 작성한 정답

select date(order_delivered_carrier_date) delivered_carrier_date
      , count(order_id) orders
from olist_orders_dataset 
where (order_delivered_carrier_date is not NULL
  and order_delivered_customer_date is NULL)
  and strftime('%Y%m',order_delivered_carrier_date) = '201701'
group by date(order_delivered_carrier_date)
order by 1;