Skip to main content
All Problems
hard0% acceptance

Refund Rate and Revenue Impact Analysis

Analyze the refund impact on each product category. For each category, calculate: total orders, refunded orders (payment status = 'refunded'), refund rate (as percentage), gross revenue (all orders), refunded revenue, and net revenue. Sort by refund_rate descending.

Schema

🔑idINT
nameTEXT
descriptionTEXTNULL
postgresql

Run your query to see results

Press Ctrl + Enter to execute