SELECT DATE_TRUNC('WEEK', ost.CREATED_AT) AS CREATED_AT, ost.delivered_at AS DELIVERED_AT, pm.approved_at AS APPROVED_AT, ost.CLIENT_TUL_CODE AS CLIENT_TUL_CODE, ost.ORDERS_TUL_CODE AS ORDERS_TUL_CODE, ost.ORDERS_STATUS AS ORDERS_STATUS, ost.ORDER_PAYMENT AS ORDER_PAYMENT, ost.SELLER AS SELLER, ost.ORDER_UUID AS SHIPMENT_ORDER_UUID, ost.PACKAGES_UUID AS PACKAGE_UUID, pm.PAYMENT_STATUS AS PAYMENT_STATUS, pm.gateway AS PAYMENT_GATEWAY, pm.payment AS PAYMENT, sum(ost.GMV_CREADO) AS SUM_GMV_CREADO, DATEDIFF('day', ost.delivered_at, pm.approved_at) AS DIFF_DAYS FROM prod_modeled.official_sale_transactions ost LEFT JOIN prod_modeled.payments pm ON ost.ORDER_uuid = pm.ORDER_UUID WHERE ost.CREATED_AT >= TO_DATE('2024-02-15') AND ost.CREATED_AT < TO_DATE('2024-12-24') AND ost.SOURCE_COUNTRY IN ('BRASIL') AND ost.ORDERS_STATUS IN ('completed') AND pm.PAYMENT_STATUS IN ('approved') GROUP BY 1,2,3,4,5,6,7,8,9,10,11,12,13 LIMIT 20000;