SQL 查询：统计及格人数和班级人数 | 数据库基础练习

"查出及格人数大于等于30人的班级：\n\nsql\nSELECT class \nFROM student \nGROUP BY class \nHAVING COUNT(*) >= 30 \nAND MIN(score) >= 60;\n\n\n附加题：查出每个班级的及格人数和不及格人数：\n\nsql\nSELECT class, \nCOUNT(CASE WHEN score >= 60 THEN 1 END) AS pass_count, \nCOUNT(CASE WHEN score < 60 THEN 1 END) AS fail_count \nFROM student \nGROUP BY class;\n\n