计算机二级VF-SQL例题作业.docVIP

作业答案 注意：select语句必须输入在命令窗口的同一行，如命令太长需分行输入，必须加续行符; 1、29（一、3） SELECT DISTINCT * FROM TABA INTO TABLE TABC.dbf 2、11（一、1） select 外币名称,现钞买入价,卖出价 from rate_exchange  into table rate_ex.dbf 4、12（一、3） SELECT * FROM 教师表 WHERE 教师表.工资 4500 ORDER BY 教师表.职工号 TO FILE one.txt 5、14（一、4） SELECT 客户号,身份证,姓名,工作单位 FROM 客户 WHERE 性别=男 INTO TABLE TABA.DBF 6、13（二、1） select 外币名称,持有数量 from rate_exchange , currency_sl where rate_exchange.外币代码=currency_sl.外币代码 and 姓名=’林诗因’ order by持有数量into table rate_temp.dbf 7、34 （二、1） select 课程名称,max(成绩) as 分数 from course , score where course.课程编号=score.课程编号 group by 课程名称 into table max.dbf 8、34 （二、2） select distinct 课程名称 from course , score where course.课程编号=score.课程编号 and score.成绩60 to file new.txt 9、49（二、1） SELECT year(出生日期) as 年份,count(姓名) as 人数 FROM customers GROUP BY 年份 ORDER BY 年份 INTO TABLE tableone.dbf 10、48（二、2） SELECT 歌手表.歌手姓名,MAX(评分表.分数) AS 最高分,MIN(评分表.分数) AS 最低分, AVG(评分表.分数) AS 平均分 FROM 歌手表,评分表 WHERE 歌手表.歌手编号 = 评分表.歌手编号 GROUP BY 歌手表.歌手姓名 ORDER BY 平均分 DESC INTO TABLE result.dbf 11、27（二、1） SELECT Book.书名, Book.作者, Book.价格 FROM book,loans,borrows WHERE Loans.借书证号 = Borrows.借书证号 AND Book.图书登记号 = Loans.图书登记号 AND Borrows.姓名 = 田亮 ORDER BY Book.价格 DESC INTO TABLE book_temp.dbf the provisions of Hunan province safety production supervision and management responsibilities (Hunan Zhengban made 2013 No. 4), resolutely implement the safety production of the party with responsibility, a pair of responsibility. Two is issued safety production administration and inspection to promote the responsibilities bear safety production supervision departments strictly and effectively assumed responsibility. The three is the establishment of enterprise production safety hidden With self correction self reporting system, promote the enterprises to implement the main responsibility for production safety. The four is the introduction of strengthening county safety production supervision ability construction work, promote safe product