例6-25.txt

vb数据库编程资料

SELECT 课号,AVG(成绩) AS 平均成绩,MAX(成绩) AS 最高成绩,
MIN(成绩) as 最低成绩,COUNT(学号) as 人数
FROM  必修课成绩
GROUP  BY  课号