Create a monthly revenue breakdown by payment method. For each month (YYYY-MM format), show separate columns for credit_card, debit_card, paypal, and bank_transfer revenue. Sort chronologically.
Schema
🔑idINT
🔗order_idINT
payment_dateTEXT
amountREAL
methodTEXT
statusTEXT
postgresql
Run your query to see results
Press Ctrl + Enter to execute