M-m-p：写了一个你看看，举例为三种课程 SELECT count(case when cou1 >=60 then 1 else null end ) /count(*) as kecheng1, count(case when cou2 >=60 then 1 else null end ) /count(*)  as kecheng2, count(case when cou3 >=60 then 1 else null end ) /count(*)  as kecheng3 from  world.gradedata001