By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| SMS_SHORT_CODE | COUNT_OF_FORWARDED | COUNT_OF_DELIVERED | COUNT_OF_EXPIRED | COUNT_OF_DELIVERY_FAILED |
|---|---|---|---|---|
| 1111 | 1 | 1 | 0 | 0 |
| 6000 | 1 | 0 | 0 | 1 |
| 5000 | 1 | 0 | 1 | 0 |
| SMS_SHORT_CODE | COUNT_OF_FORWARDED | COUNT_OF_DELIVERED | COUNT_OF_EXPIRED | COUNT_OF_DELIVERY_FAILED |
|---|---|---|---|---|
| 1111 | 1 | 1 | 0 | 0 |
| 6000 | 1 | 0 | 0 | 1 |
| 5000 | 1 | 0 | 1 | 0 |