This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Marketplace Trust & Safety Analyst at Amazon. The seller compliance team wants to flag sellers whose cancellation rate exceeds 5%. A high cancellation rate can indicate inventory management problems, listing inaccuracies, or policy violations. You need to compute each seller's cancellation rate from their order item fulfillment statuses and filter to only those above the threshold.
You are a Marketplace Trust & Safety Analyst at Amazon. The seller compliance team wants to flag sellers whose cancellation rate exceeds 5%. A high cancellation rate can indicate inventory management problems, listing inaccuracies, or policy violations. You need to compute each seller's cancellation rate from their order item fulfillment statuses and filter to only those above the threshold.