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