I want to select the records like

If grade=F
message="Very poor fail"
If grade=E
message="very poor
endif
endif

select code,name,grade,;
CAST(SUM(IIF(grade="F",1,0)) AS I) "Very poor fail"
CAST(SUM(IIF(grade="E",1,0)) AS I) "Very poor "
..........
from student
thanks