Partition-Pruned Monthly Revenue Query

Interviewer prompt: orders is range-partitioned by order_date. Return total completed revenue for January 2025 while preserving partition pruning.

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