SELECT multiple column values

Not sure why I am not making my needs to vague, not trying too.
I would like your help.
Tried many ways with the SUM, with the ELSE and without:
Mission is Adding 3 values to a process I have already, written pulling data from another database and splitting it into values when the tables column (container) is either cans, bottles or kegs and need put into different columns with the same names for further processing.