Count the payments for every method and status pair. Add a total row for each method
(with NULL as the status), a total row for each status (with NULL as the method) and a grand
total (NULL in both). Show method, status and payments.
End your query with ORDER BY method, status. The NULL total rows sort last.
| payments |
|---|
| payment_id (PK) |
| amount |
| method |
| status |
Count the payments for every method and status pair. Add a total row for each method
(with NULL as the status), a total row for each status (with NULL as the method) and a grand
total (NULL in both). Show method, status and payments.
End your query with ORDER BY method, status. The NULL total rows sort last.
| payments |
|---|
| payment_id (PK) |
| amount |
| method |
| status |
| method | status | payments |
|---|---|---|
| upi | pending | 8 |
| upi | success | 38 |
| upi | failed | 4 |
| upi | refunded | 15 |
| upi | NULL | 65 |
| card | pending | 7 |
| card | success | 46 |
| card | failed | 5 |
| card | refunded | 16 |
| card | NULL | 74 |
| netbanking | pending | 10 |
| netbanking | success | 32 |
| netbanking | failed | 5 |
| netbanking | refunded | 9 |
| netbanking | NULL | 56 |
| cod | pending | 7 |
| cod | success | 35 |
| cod | failed | 5 |
| cod | refunded | 14 |
| cod | NULL | 61 |
| wallet | pending | 11 |
| wallet | success | 31 |
| wallet | failed | 4 |
| wallet | refunded | 13 |
| wallet | NULL | 59 |
| NULL | pending | 43 |
| NULL | success | 182 |
| NULL | failed | 23 |
| NULL | refunded | 67 |
| NULL | NULL | 315 |
Run query to see output