高考问答gfrp:vfp题，这道题怎么改？ 看里面！
来源：百度文库 编辑：高考问答 时间：2024/04/29 21:19:57
下面的程序在第2行、第3行、第4行、第5行有错误，请直接在错误处修改。 修改时,不可改变SQL语句的结构和短语的顺序，不允许增加或合并行。
OPEN DATABASE sdb
SELECT 学号,姓名,AVG(成绩) 平均成绩,COUNT(成绩) 选课门数;
FROM student JOIN sc OF student.学号 = sc.学号;
WHERE 性别 = "女" AND AVG(成绩) >= 75;
GROUP BY 学号 ;
ORDER BY 4 desc ;
INTO TABLE three
OPEN DATABASE sdb
SELECT 学号,姓名,AVG(成绩) 平均成绩,COUNT(成绩) 选课门数;
FROM student JOIN sc OF student.学号 = sc.学号;
WHERE 性别 = "女" AND AVG(成绩) >= 75;
GROUP BY 学号 ;
ORDER BY 4 desc ;
INTO TABLE three
OPEN DATABASE sdb
SELECT student.学号,姓名,AVG(成绩) as 平均成绩,COUNT(成绩) as 选课门数;
FROM student JOIN sc on student.学号 = sc.学号;
WHERE 性别 = "女" AND 平均成绩 >= 75;
GROUP BY student.学号 ;
ORDER BY 4 desc ;
INTO TABLE three
第2行、第3行、第4行、第5行是有错误,修改如下:
OPEN DATABASE sdb
SELECT student.学号,姓名,AVG(成绩) 平均成绩,COUNT(成绩) 选课门数;
FROM student JOIN sc ON student.学号 = sc.学号;
WHERE 性别 = "女" AND 平均成绩 >= 75;
GROUP BY student.学号 ;
ORDER BY 4 desc ;
INTO TABLE three