我正在使用codeigniter。我想这样，如果我发现1个主题=失败，那么所有结果=f/失败。我知道如何写查询。我用 group by 因为学生有很多班级资料。
我的table

如何编写此查询。我想知道如果一个或多个科目都不及格。然后getmark=f或getmark=4.40，就像这样。
查询

CREATE VIEW result as SELECT name as name,roll as roll,class as 
 class,subject_name as subject,exam_type as exam_type,sum(full_mark) as 
full_mark,sum(getmark) as getmark, if(gpa =='f', 'F',sum(gpa)) as 
total_gpa FROM mark GROUP by roll,class,exam_type