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