php - 如果条件允许，则创建视图表

Question

我正在使用codeigniter。如果我发现 1 个主题 = 失败然后所有结果 =f/失败，我想这样计算。我如何写查询。我使用 group bybeasue 1 学生有很多班级数据。

我的桌子

这个查询怎么写。我想如果一个或多个主题失败意味着 f 。然后 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

标签： phpmysqlcodeignitermysqli