SQL Case, Trim Statement

select * from tbl3
SELECT sno,total,average
, CASE WHEN average 50 THEN 'Fail'
WHEN average>50 THEN 'Pass'
ELSE 'Not Eligible'
END as result
FROM tbl3;
SELECT sno,average,average%2 FROM tbl3;
Example:2
case when ltrim(rtrim(a.Program)) = ltrim(rtrim(pgm.prgm_name))
and ltrim(rtrim(a.Partner)) = ltrim(rtrim(Partner.Partner_Name))
and ltrim(rtrim(a.Measure)) = ltrim(rtrim(msre.Msre_Name))
then 1
else 0
end Flag