SELECT T.TYPE ,SUM(T.AMOUNT) AMOUNT ,(SUM(AMOUNT) / (SELECT SUM(T1.AMOUNT) FROM TABLE1 T1)) PERCENT FROM TABLE1 T GROUP BY T.TYPE;