For each month of 2024 (month = first day), count orders paid by upi, card and cod in three columns.
12 rows with columns month, upi, card, cod — first 3 shown:
| # | ||||
|---|---|---|---|---|
| 1 | 2024-01-01 00:00:00 | 1 | 1 | 1 |
| 2 | 2024-02-01 00:00:00 | 2 | 1 | 0 |
| 3 | 2024-03-01 00:00:00 | 1 | 1 | 1 |
Run your code to see the output here.