若有如下SQL语句: SELECT班级,班级名,SUM(工资); FROM班级,教师; WHERE班级,班级号=教师,班级号; GROUP BY班级,班级号 该语句的查询结果是()
A.各个班级教师工资的平均工资(average wage)
B.各个班级教师的工资合计
C.所有教师工资的平均工资(average wage)
D.所有教师的工资合计
B、各个班级教师的工资合计
A.各个班级教师工资的平均工资(average wage)
B.各个班级教师的工资合计
C.所有教师工资的平均工资(average wage)
D.所有教师的工资合计
B、各个班级教师的工资合计
A.SELECT班级,AVG(语文)FROM cj201907 WHERE选课LIKE %物理AND班级=9
B.SELECT班级,AVG(语文)FROM cj201907 WHERE选课=物理AND 9班
C.SELECT班级,AVG(语文)FROM cj201907 WHERE 班级=9 AND 选课LIKE物理%
A.SELECT班级,COUNT(学号)FROM cj201907 WHERE 物理>90 AND 历史>90 GROUP BY班级I
B.SELECT 班级,COUNT(学号)FROM cj201907 WHERE历史>=90 OR物理>=90 GROUP BY班级
C.SELECT班级,COUNT(学号)FROM cj201907 WHERE物理>=90 0R历史>90 GROUP BY班级
A.SELECT姓名,总成绩,选课FROMcj201907WHERE班级=3AND选课LIKE"%物理"ORDERBY总成绩DESC
B.SELECT姓名,总成绩,选课FROMcj201907WHERE选课LIKE"物理%"ORDERBY总成绩DESC
C.SELECT姓名,总成绩,选课FROMcj201907WHERE选课LIKE"%物理%"AND班级=3ORDERBY总成绩DESC
A.SELECT姓名,化学,化学赋分 FROM cj201907 WHERE班级=6 AND选课LIKE"%化学%" ORDER BY化学DESC
B.SELECT 姓名,化学,化学赋分FROM cj201907 WHERE选课LIKE"%化学%"AND 6班ORDER BY化学DESC
C.SELECT姓名,化学,化学赋分FROM cj201907 WHERE选课LIKE"%化学%"OR班级=6 ORDER BY化学DESC
A.SELECT*FROMDepartmentLEFTJOINEmployeeONDepartment.ID=Employee.DepartmentIDANDEmployee.DepartmentID=NULL
B.SELECT*FROMDepartmentLEFTJOINEmployeeWHEREDepartment.ID=Employee.DepartmentIDANDEmployee.DepartmentIDISNULL
C.SELECT*FROMDepartmentLEFTJOINEmployeeONDepartment.ID=Employee.DepartmentIDWHEREEmployee.DepartmentIDISNULL
D.SELECT*FROMDepartmentLEFTJOINEmployeeONDepartment.ID=Employee.DepartmentIDANDEmployee.DepartmentIDISNULL
A.系统会提示语句出错
B.会生成一个按"单价"升序排序的表文件,将原来的stock.dbf文件覆盖
C.会生成一个按"单价"降序排序的表文件,将原来的stock.dbf文件覆盖
D.不会生成排序文件,只在屏幕上显示一个按"单价"升序排序的结果
A.SELECT DISTINCT学号FROM SC WHERE”成绩”>75
B.SELECT DISTINCT学号FROM SC WHERE成绩>75
C.SELECT DISTINCT学号FROM SC WHERE成绩>”75&rdquo
D.SELECT DISTINCT”学号”FROM SC WHERE”成绩”>75
A.7.48
B.9.99
C.11.73
D.15.20