Try this:
SELECT CAT, SUM(VAL_1) AS VAL_1, SUM(VAL_2) AS VAL_2, SUM(VAL_3) AS VAL_3
FROM TAbleName
GROUP BY CAT
If you would like to get only 2 first letters/chars from
Cat
, use this:
SELECT LEFT(CAT,2) AS CAT, SUM(VAL_1) AS VAL_1, SUM(VAL_2) AS VAL_2, SUM(VAL_3) AS VAL_3
FROM TAbleName
GROUP BY LEFT(CAT,2)