题库 产品/项目/运营 题目列表 一个数据表student(No, Name, Sex, Age, Dept),以下...
单选题

一个数据表student(No, Name, Sex, Age, Dept),以下不能完成对应操作的sql语句是?

A.

查询所有14岁到18岁之间的男学生,并输出他们的姓名和年龄:<br>Select Name, Age From<br>student Where sex = ‘male’ and age between 14 and 18

B.

查询所有姓名包含“妍”的学生:<br>Select * From student<br>Where name like “_妍%”

C.

统计表中学生涉及的院系个数:<br>Select<br>count(*)From (Select distinct Dept From student)

D.

统计表中不同系别的男生的平均年龄,并按从大到小排列:<br>Select Dept, avg(Age)<br>From student Where sex = ‘male’ Group by Dept Order by avg(Age)

题目信息
校招真题
-
正确率
0
评论
7
点击