Credit orders pending for status update
Overall Data
SELECT
Orders.uuid,
Orders.source_country,
Orders.created_at,
Orders.status,
SHIPMENTS.schedule,
Orders.payment_method,
DATEDIFF(DAY, SHIPMENTS.schedule, CURRENT_DATE()) AS dias_de_atraso
FROM
analytics.prod_modeled.Orders Orders
INNER JOIN
analytics.prod_modeled.SHIPMENTS SHIPMENTS ON Orders.uuid = SHIPMENTS.order_uuid
WHERE
Orders.created_at >= '2023-01-01' AND
Orders.status NOT IN ('completed', 'cancelled') AND
SHIPMENTS.schedule < CURRENT_DATE() AND
(Orders.payment_method = 'CupoTul' OR Orders.payment_method = 'ticket');
select * from data_view where dias_de_atraso > 2