第22题: [单项选择]Questions 11 to 18 are based on the conversation you have just heard. A. Bob will probably remain angry until the man apologizes. B. Bob might not be really angry with the man. C. Bob has also been mad at her recently. D. The man should ask Bob to apologize. 参考答案:A 答案解析:[听力原文] M: I don’t know what I could have done to make Bob so mad at me. W: Me neither, but it’
第34题: [单项选择]用SQL语言检索选修课程在5门以上(含5门)的学生的学号、姓名和平均成绩,并按平均成绩降序排序,正确的命令是( )。 A. SELECT S.学号,姓名,平均成绩 FROM S,SC; B. SELECT 学号,姓名,AVG(成绩) FROM S,SC; C. SELECT S.学号,姓名,AVG(成绩) 平均成绩 FROM S,SC; D. SELECT S.学号,姓名,AVG(成绩) 平均成绩 FROM S,SC; 参考答案:D 答案解析:[解析] 选项A)中,平均成绩不是表中字段,不能直接显示,要用“AVG(成绩)平均成绩”来实现,故错误;选项B),题中要求查询的是“平均成绩”字段,而不是AVG(成绩),并且,此题要求先按学号分组,然