I have a stored procedure and it results like this:
Governors AUTO 07313570121 1 3.69 2.01 2.01 1.68 83.58%
Governors AUTO 07319354850 1 2.79 1.8 1.80 0.99 55.00%
Governors AUTO 07480400400 1 17.69 9.71 9.7117 7.9783 82.15%
Governors AUTO 07723100038 1 2.89 1.55 1.55 1.34 86.45%
Governors BEER 01820000031 6 4.69 23.34 3.888 0.8 20.57%
Governors BEER 01820000051 6 4.69 23.34 3.888 0.802 20.63%
Governors BEER 01820000106 1 6.39 4.93 4.93 1.46 29.61%
i want to sum like as fallows:
Governors AUTO 4 27.06 15.07
Governors AUTO 13 13.07 51.61