SELECT Sum(表1.分数) AS 总计, Max(表1.分数) AS 最大值, Min(表1.分数) AS 最小值, Count(表1.分数) AS 分数计数, ([总计]-[最大值]-[最小值])/([分数计数]-2) AS 平均分, ([总计]-[最大值]-[最小值]) AS 有效总分, [分数计数]-2 AS 有效总数FROM 表1;
去最大分最小分后的平均分
点击下载此附件