web | Java

写出SQL60分以上合格,查出所有学生合格与不合格科目的总数,格式为(student_num,passed,failed)

千锋教育

select student_num, sum(case when score >= 60 then 1 else 0 end) `passed`, 

sum(case when score < 60 then 1 else 0 end) `failed` from course_score group by student_num