针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sa

1.针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄。选项： A:select sdept ,avg(sage) from student group by sdept having avg(sage) >20; B:select sdept ,avg(sage) from student where ssex='女' and avg(sage) >20 group by sdept ; C:select sdept ,avg(sage) from student where ssex='女' group by sdept; D:select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >20

2.针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄。选项： A:select sdept ,avg(sage) from student group by sdept having ssex='女' and avg(sage) >20; B:select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >20; C:select sdept ,avg(sage) from student where ssex='女' group by sdept ; D:select sdept ,avg(sage) from student group by sdept having avg(sage) >20

3.针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄。选项： A、select sdept ,avg(sage) from student group by sdept having ssex='女' and avg(sage) >20 B、select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >20 C、select sdept ,avg(sage) from student where ssex='女' group by sdept D、select sdept ,avg(sage) from student group by sdept having avg(sage) >20

4.针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄。（）选项： A:select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >2; B:select sdept ,avg(sage) from student group by sdept having ssex='女' and avg(sage) >20; C:select sdept ,avg(sage) from student where ssex='女' group by sdept ; D:select sdept ,avg(sage) from student group by sdept having avg(sage) >20

5.针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及系女生平均年龄。选项： A:select sdept ,avg(sage) from student group by sdept having ssex='女' and avg(sage) >20; B:select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >20; C:select sdept ,avg(sage) from student where ssex='女' group by sdept ; D:select sdept ,avg(sage) from student group by sdept having avg(sage) >20

6.针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄。选项： A:select sdept ,avg(sage) from student where ssex='女' and avg(sage) >20 group by sdept ; B:select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >20; C:select sdept ,avg(sage) from student where ssex='女' group by sdept ; D:select sdept ,avg(sage) from student group by sdept having avg(sage) >20

7.针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄。选项： A、select sdept ,avg(sage) from student group by sdept having ssex='女' and avg(sage) >20 B、select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >20 C、select sdept ,avg(sage) from student where ssex='女' group by sdept D、select sdept ,avg(sage) from student group by sdept having avg(sage) >20

8.针对表Student（sno, sname, ssex, sage, sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄。选项： A:select sdept ,avg(sage) from student group by sdept having ssex='女' and avg(sage) >20; B:select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >2; C:select sdept ,avg(sage) from student where ssex='女' group by sdept ; D:select sdept ,avg(sage) from student group by sdept having avg(sage) >20

9.单选题（2分）针对表Student(sno, sname, ssex, sage, sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄( )。选项： A:select sdept ,avg(sage) from student group by sdept having ssex='女' and avg(sage) >20 B:select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >20 C:select sdept ,avg(sage) from student where ssex='女' group by sdept D:select sdept ,avg(sage) from student group by sdept having avg(sage) >20

10.单选题]针对表Student(sno, sname, ssex, sage, sdept),其中sno为学号,sname为姓名,ssex为性别,sage为年龄,sdept为系别。查询女生平均年龄超过20岁的系别以及女生平均年龄。选项： A:select sdept ,avg(sage) from student group by sdept having avg(sage) >20 B:select sdept ,avg(sage) from student where ssex='女' group by sdept C:select sdept ,avg(sage) from student where ssex='女' group by sdept having avg(sage) >20 D:select sdept ,avg(sage) from student where ssex='女' and avg(sage) >20 group by sdept

11.针对学生表student（sno,sname,ssex,sage,sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询学生的姓名sname，系别sdept和年龄sage，显示时按系别升序排列，系别相同的再按年龄降序排列。（）选项： A:select sname, sdept, sage from student order by sdept desc , sage; B:select * from student order by sdept , sage; C:select sname, sdept, sage from student order by sdept , sage desc; D:select * from student order by sdept desc, sage

12.针对学生表student（sno,sname,ssex,sage,sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询学生的姓名sname，系别sdept和年龄sage，显示时按系别升序排列，系别相同的再按年龄降序排列。（）选项： A:select * from student order by sdept , sage; B:select sname, sdept, sage from student order by sdept , sage desc; C:select sname, sdept, sage from student order by sdept desc , sage; D:select * from student order by sdept desc, sage

13. 针对学生表student（sno,sname,ssex,sage,sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询学生的姓名sname，系别sdept和年龄sage，显示时按系别升序排列，系别相同的再按年龄降序排列。（）选项： A: select sname, sdept, sage from student order by sdept , sage desc;; B: select * from student order by sdept , sage;; C:select sname, sdept, sage from student order by sdept desc , sage;; D:select * from student order by sdept desc, sage;

14.针对学生表student（sno,sname,ssex,sage,sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询学生的姓名sname，系别sdept和年龄sage，显示时按系别升序排列，系别相同的再按年龄降序排列。（）（3.0分）选项： A:select sname, sdept, sage from student order by sdept , sage desc B:select * from student order by sdept , sage C:select sname, sdept, sage from student order by sdept desc , sage D:select * from student order by sdept desc, sage

15.针对学生表student(sno,sname,ssex,sage,sdept),其中sno为学号,sname为姓名,ssex为性别,sage为年龄,sdept为系别。查询学生的姓名sname,系别sdept和年龄sage,显示时按系别升序排列,系别相同的再按年龄降序排列。( )A．select sname, sdept, sage from student order by sdept , sage descB．select * from student order by sdept , sageC．select * from student order by sdept desc, sageD．select sname, sdept, sage from student order by sdept desc , sage

16.【单选题】针对学生表student（sno,sname,ssex,sage,sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询学生的姓名sname，系别sdept和年龄sage，显示时按系别升序排列，系别相同的再按年龄降序排列。()A. select * from student order by sdept , sageB. select sname, sdept, sage from student order by sdept , sage descC. select sname, sdept, sage from student order by sdept desc , sageD. select * from student order by sdept desc, sage

17.在学生选课数据库中有学生表student(sno,sname,ssex,sage,sdept)，课程表course(cno,cname)及学生选课表sc(sno,cno,grade)，其中sno是学号，sname是姓名，ssex是性别，sage是年龄，sdept是系别，cno是课程号，cname是课程名，grade是成绩。以下（）SQL语句可以实现查询“CS”系并且年龄超过20岁的学生姓名。选项： A:select sname from student where sdept=’CS‘ and sage>20; B:select sname from student where sdept=’CS‘intersectselect sname from student where sage>20; C:select sname from student where sdept=’CS‘exceptselect sname from student where sage<=20; D:select sname from student where sdept=’CS‘unionselect sname from student where sage>20

18.在学生选课数据库中有学生表student(sno,sname,ssex,sage,sdept)，课程表course(cno,cname)及学生选课表sc(sno,cno,grade)，其中sno是学号，sname是姓名，ssex是性别，sage是年龄，sdept是系别，cno是课程号，cname是课程名，grade是成绩。以下（）SQL语句可以实现查询“CS”系并且年龄超过20岁的学生姓名。选项： A:select sname from student where sdept=’CS‘ and sage>20; B:select sname from student where sdept=’CS‘intersectselect sname from student where sage>20; C:select sname from student where sdept=’CS‘exceptselect sname from student where sage<=20; D:select sname from student where sdept=’CS‘unionselect sname from student where sage>20

19.在学生选课数据库中有学生表student(sno,sname,ssex,sage,sdept)，课程表course(cno,cname)及学生选课表sc(sno,cno,grade)，其中sno是学号，sname是姓名，ssex是性别，sage是年龄，sdept是系别，cno是课程号，cname是课程名，grade是成绩。以下（）SQL语句可以实现查询“CS”系并且年龄超过20岁的学生姓名。选项： A、select sname from student where sdept=’CS‘ and sage>20 B、select sname from student where sdept=’CS‘intersectselect sname from student where sage>20 C、select sname from student where sdept=’CS‘exceptselect sname from student where sage<=20 D、select sname from student where sdept=’CS‘unionselect sname from student where sage>20

20.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在16至30岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（）。选项： A:Select * From Student Where Sage between 16 and 30; B:Select Sname, Sage From Student Where Sage between 16 and 30; C:Select Sname, Sage From Student Where Sage >= 16 and Sage<= 30; D:Select Sname, Sage From Student Where Sage >= 16 or Sage<= 30

21.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在16至30岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（）。选项： A:Select Sname, Sage From Student Where Sage >= 16 or Sage<= 30; B:Select Sname, Sage From Student Where Sage >= 16 and Sage<= 30; C:Select * From Student Where Sage between 16 and 30; D:Select Sname, Sage From Student Where Sage between 16 and 30

22.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在16至30岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（）。选项： A:Select * From Student Where Sage between 16 and 30; B:Select Sname, Sage From Student Where Sage between 16 and 30; C:Select Sname, Sage From Student Where Sage >= 16 and Sage<= 30; D:Select Sname, Sage From Student Where Sage >= 16 or Sage<= 30

23.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在17至25岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（）。选项： A:Select Sname, Sage From Student Where Sage between 16 and 30;; B:Select Sname, Sage From Student Where Sage >= 16and Sage<= 30;; C:Select * From Student Where Sage between 16 and 30;; D:Select Sname, Sage From Student Where Sage >= 16 or Sage<= 30;

24.针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在16至30岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（）。选项： A:select Sname, Sage From Student Where Sage >= 16 and Sage<= 30; B:select Sname, Sage From Student Where Sage >= 16 or Sage<= 30; C:select * From Student Where Sage between 16 and 30; D:select Sname, Sage From Student Where Sage between 16 and 30