C：[图书订单表]![单价]*[图书订单表]![数量] D：=[图书订单表]![单价]*[图书订单表]![数量] 答案：B
131、根据关系模型Students(学号,姓名,性别,专业)下列SQL语句中有错误的是______。 A：SELECT * FROM Students
B：SELECT COUNT(*) 人数 FROM Students C：SELECT DISTINCT 专业 FROM Students D：SELECT 专业 FROM Students 答案：B
132、根据关系模型Students(学号,姓名,性别,专业)下列SQL语句中有错误的是______。
A：SELECT * FROM Students WHERE专业=\计算机\
B：SELECT * FROM Students WHERE 1 <> 1 C：SELECT * FROM Students WHERE \姓名\李明 D：SELECT * FROM Students WHERE 专业=\计算机\科学\
答案：C
133、根据关系模型Students(学号,姓名,性别,专业)下列SQL语句中有错误的是______。
A：SELECT * FROM Students ORDER BY 学号 B：SELECT * FROM Students ORDER BY 学号 ASC
C：SELECT * FROM Students ORDER BY 学号 DESC
D：SELECT * FROM Students ORDER BY 学号 ESC 答案：D
134、根据关系模型Students(学号,姓名,性别,专业)下列SQL语句中有错误的是______。
A：SELECT COUNT(*) FROM Students GROUP BY 性别
B：SELECT COUNT(*) FROM Students GROUP BY 性别 WHERE 专业 = \计算机\
C：SELECT COUNT(*) FROM Students GROUP BY 性别 HAVING 专业 = \计算机\
D：SELECT COUNT(*) AS 人数 FROM Students GROUP BY 性别 答案：B
135、根据关系模型Students(学号,姓名,性别,专业)下列SQL语句正确的是______。
A：SELECT * FROM Students WHERE \姓名\李明
B：SELECT COUNT(*) FROM Students GROUP BY 性别 WHERE 专业 = \计算机\
C：SELECT * FROM Students ORDER BY 学号 DESC
D：SELECT * DISTINCT 专业 FROM Students 答案：C
136、根据关系模型Students(学号,姓名,性别,专业)，查找姓\王\的学生应使用______。
A：SELECT * FROM Students WHERE 姓名 Like\王*\
B：SELECT * FROM Students WHERE 姓名 Like\王]\
C：SELECT * FROM Students WHERE 姓名=\王*\ D：SELECT * FROM Students WHERE 姓名==\王*\答案：A
137、根据关系模型Students(学号,姓名,性别,专业)，查找专业中含有\计算机\的学生应使用______。 A：SELECT * FROM Students WHERE 专业 Like\计算机*\
B：SELECT * FROM Students WHERE 专业 Like\计算机*\
C：SELECT * FROM Students WHERE 专业=\计算机*\
D：SELECT * FROM Students WHERE 专业==\计算机*\答案：B
138、根据关系模型Students(学号,姓名,性别,专业,成绩)，查找成绩在80到90之间的学生应使用______。 A：SELECT * FROM Students WHERE 80<成绩<90 B：SELECT * FROM Students WHERE 80<成绩 OR
成绩<90
C：SELECT * FROM Students WHERE 80<成绩 AND 成绩<90
D：SELECT * FROM Students WHERE 成绩 IN (80,90) 答案：C
139、在SQL查询语句中，子句\性别=\女\AND 工资额>2000\的作用是处理______。
A：性别为\女\并且工资额大于2000（包含）的记录 B：性别为\女\或者工资额大于2000（包含）的记录 C：性别为\女\并且工资额大于2000（不包含）的记录
D：性别为\女\或者工资额大于2000（不包含）的记录 答案：C
140、根据关系模型Students(学号,姓名,性别,出生年月)，统计学生的平均年龄应使用______。
A：SELECT COUNT() AS 人数,AVG(YEAR(出生年月)) AS 平均年龄 FROM Students