SELECT SUM(colA) as 'colA',
       SUM(colB) as 'colB'
FROM tblName
WHERE colA,colB REGEXP 'Fail'
OR colA, colB='Pass'
ORDER BY colA, colB;