I have a following database

```
id  item_id  date        system_code  value
#1  0001     01-01-2019  0999         10
#2  0001     02-01-2019  0888         15
#3  0001     01-01-2019  0999         10
#4  0002     02-01-2019  0777         20
#5  0002     03-01-2019  0777         35

```

And the result I want to achieve would look like so, with values for system\_code columns being sum of "value"

```
  item_id  date        0999  0888  0777
  0001     01-01-2019  20        
  0001     02-01-2019        15
  0002     02-01-2019              20
  0002     03-01-2019              35

```

My problem is that there is over 1000 distinct values for system\_code so I can't type them by hand.
Database has nearly billion entries so anything that would calculate quickly would be perfect.