方法一: 0select 学生.学号,姓名,avg(成绩) as 平均分,count(*) as 选课门数 from 学生,选课. where 学生.学号=选课.学号; order by 平均分desc. group by 选课.学号 having count(*)>=5. into table stu_temp
方法二: 0select a.学号,a.姓名,avg(b.成绩) 平均分,count(b.课程号) 选课门数 from 学生 a,选课 b where a.学号=b.学号 group by b.学号 having(count(b.课程号))>=5 order by 平均分 desc into dbf stu_temp