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