this is a possible solution

SELECT keyid1

, sum (min3s) as min3s

, sum (min2s) as min2s

, sum (norm) as norm

, sum (plus2s) as plus2s

, sum (plus3s) as plus3s

FROM (

SELECT keyid1

, case WHEN...