SELECT class as 班級(jí), COUNT(CASE when score>=60 THEN score END) as 大于60, COUNT(CASE when score<60 THEN score END) as 小于60 FROM test_class GROUP BY class;