select CertYear, sum(QtyMaster) as QtyMaster, sum(QtyInstr) as QtyInstr

, sum(QtyTrain) as QtyTrain

from(

select v.CertYear

, case when v.CertCode = 'HI-Master' then sum(v.Quantity)

else 0

end as QtyMaster

, case when...