SELECT SUM(agsms) AS s, SUM(mh) AS h,
SUM(IIF(gsm= 1 , agsma,  0 )) AS a1,      //А76
SUM(IIF(gsm= 2 , agsma,  0 )) AS a2,      //Аи92
SUM(IIF(gsm= 3 , agsma,  0 )) AS a3       //ДТ
FROM data
WHERE ida=:KA