针对表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
发布时间:2024-05-07 19:17:26