Partition-Friendly Weekly Revenue Query

Return total paid revenue for last 7 days with partition-prunable predicate.

orders(order_id, status, total_amount, created_at) -- partitioned by created_at