Run to view results
Run to view results
Credit orders pending for status update
Run to view results
Run to view results
Run to view results
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');
Run to view results
select * from data_view where dias_de_atraso > 2
Run to view results