Q. https://solvesql.com/problems/estimated-delivery-date/
SELECT DATE(order_purchase_timestamp) AS purchase_date,
COUNT(CASE WHEN order_delivered_customer_date <= order_estimated_delivery_date THEN order_id ELSE NULL END) AS success,
COUNT(CASE WHEN order_delivered_customer_date >= order_estimated_delivery_date THEN order_id ELSE NULL END) AS fail
FROM olist_orders_dataset
WHERE order_purchase_timestamp BETWEEN '2017-01-01 00:00:00' AND '2017-01-31 23:59:59'
GROUP BY DATE(order_purchase_timestamp)
ORDER BY purchase_date ASC
