PayPal's finance team imported merchant payouts from an old system that stored amounts as text like '$1,240.50', with a few 'N/A' and 'pending' values mixed in.
For each month of paid_on (labelled like 2026-01), show the number of payouts with a valid amount, the number without one, and the total of the valid amounts.
Expected output
Example of the shape (made-up values):
| month | valid_payouts | invalid_payouts | total_paid |
|---|---|---|---|
| 2026-01 | 36 | 3 | 31250.75 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.