VFP9
243688667@
243688667@
坚守VFP最后的阵地
SELECT count(成绩) as 参考科次,课程名称 from 124次自考成绩(建筑) group by 课程名称 into table lsb1 SELECT count(成绩) as 合格科次,课程名称 from 124次自考成绩(建筑) where 成绩>=60 group by 课程名称 into table lsb2 SELECT lsb1.课程名称,lsb1.参考科次,lsb2.合格科次,lsb2.合格科次/lsb1.参考科次 合格率 from lsb2 left join lsb1 on lsb1.课程名称=lsb2.课程名称 into table lsb3
SELECT 课程名称,COUNT(*) 人数,SUM(IIF(成绩<60,1,0)) 不合格人数,SUM(IIF(成绩>=60,1,0)) 合格人数,SUM(IIF(成绩>=60,1,0))*100/COUNT(*) AS 合格率 FROM JZCJ GROUP BY 1