Scenario: Partition Pruning Failure

Interviewer prompt: Query on partitioned sales table scans many partitions unexpectedly. Suggest SQL rewrite and schema checks to restore pruning.

sales partitioned by sale_date