Skip to main content
All Problems
medium0% acceptance

Payment Method Breakdown

The finance team wants to know how revenue is distributed across payment methods. For each payment method, show the number of completed payments, the total amount, and the percentage of total revenue (rounded to 1 decimal). Sort by total amount descending.

Schema

🔑idINT
🔗order_idINT
payment_dateTEXT
amountREAL
methodTEXT
statusTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute