Predicate Pushdown Before Heavy Join

Return paid orders in last 7 days with customer segment. Keep query shape optimizer-friendly for large orders table.

orders(order_id, customer_id, status, created_at), customers(customer_id, segment)