ID  |  Label | Quantity
 1      aaa      10
 1      bbb      20
 2      ccc      20

ID  |  Total Quantity
 1       60
 2       20

ID  |   Label    | Quantity
 1       aaa         10       (read from reference table, remaining 50)
 1       bbb         20       (read from reference table, remaining 30)
 1       [NULL]      30       (no label in reference table, remaining 0)
 2       ccc         20       (read from reference table, remaining 0)