中科新闻网iphone 一年销售量:vfp题，简单应用怎么做？
来源：百度文库 编辑：中科新闻网 时间：2024/05/06 10:51:19
*下面的程序在第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
*修改时,不可改变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
第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
4,5句也有错么：
OPEN DATABASE sdb
SELECT 学号,姓名,AVG(成绩) AS 平均成绩,COUNT(成绩) AS 选课门数;
FROM student INNER JOIN sc ON student.学号 = sc.学号;
WHERE 性别 = "女" AND AVG(成绩) >= 75;
GROUP BY 学号;
ORDER BY 4 desc ;
INTO TABLE three