Something like this?
select kqt.OrderNum
,QCStatus = (case when count(kqt.OrderNum) - count(kqt.QCPass) > 0 then 'QC Incomplete'
else 'QC Complete'
end)
from dbo.kiQCTest kqt
group by kqt.OrderNum
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.