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