How can I put following two columns in pivot form. Thanks in advance!
create table claim
(posted_date date,
claim number
)
| posted date | sum_claim |
| 2015-10 | 582 |
| 2015-11 | 347 |
| 2015-12 | 458 |
| 2015-7 | 456 |
| 2015-8 | 461 |
| 2015-9 | 492 |
| 2016-1 | 376 |
| 2016-10 | 446 |
| 2016-11 | 329 |
| 2016-12 | 434 |
| 2016-2 | 396 |
| 2016-3 | 460 |
| 2016-4 | 551 |
| 2016-5 | 401 |
| 2016-6 | 376 |
| 2016-7 | 454 |
| 2016-8 | 476 |
| 2016-9 | 498 |
| 2017-1 | 408 |
| 2017-10 | 435 |
| 2017-11 | 510 |
| 2017-12 | 462 |
| 2017-2 | 388 |
| 2017-3 | 484 |
| 2017-4 | 408 |
| 2017-5 | 404 |
| 2017-6 | 569 |
| 2017-7 | 398 |
| 2017-8 | 490 |
| 2017-9 | 605 |
| 2018-1 | 389 |
| 2018-2 | 378 |
| 2018-3 | 541 |
| 2018-4 | 392 |
| 2018-5 | 364 |
| 2018-6 | 443 |
| |