SELECT DATE_TRUNC('WEEK', ost."CREATED_AT") AS "CREATED_AT", ost."SOURCE_COUNTRY" AS "SOURCE_COUNTRY", 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", cl."TIME_LAST_ORDER" AS "TIME_LAST_ORDER", sum(ost."GMV_CREADO") AS "SUM(GMV_CREADO)", MAX(ofc.product_limit_approved_amount) AS product_limit_approved_amount FROM prod_modeled.official_sale_transactions ost LEFT JOIN analytics.prod_modeled.clients as cl ON ost."CLIENT_UUID" = cl."UUID" LEFT JOIN ANALYTICS.PARADIME_AHERNANDEZ_MODELED.OFFICIAL_FINTECH_CONTROL ofc ON ost."CLIENT_TUL_CODE" = ofc."CLIENT_TUL_CODE" WHERE ost."CREATED_AT" >= TO_DATE('2024-07-01') AND ost."CREATED_AT" < TO_DATE('2024-12-24') AND ost."SOURCE_COUNTRY" IN ('MEXICO') AND ost."SELLER" NOT IN ('bodega Fontibon') AND ost."ORDER_PAYMENT" IN ('Efectivo al recibir') GROUP BY DATE_TRUNC('WEEK', ost."CREATED_AT"), ost."SOURCE_COUNTRY", ost."CLIENT_TUL_CODE", ost."ORDERS_TUL_CODE", ost."ORDERS_STATUS", ost."ORDER_PAYMENT", ost."SELLER", cl."TIME_LAST_ORDER"

select source_country, order_payment from prod_modeled.official_sale_transactions ost group by source_country , order_payment order by source_country