求不及格人数:select count(1) from stuMarks where writtenExam<60求平均分select AVG(writtenExam) from stuMarks
人数用count,总分用sum,然后也可以求出平均分
SELECT SUM(expression ),COUNT(*)FROM tablesWHERE predicates;