单选题

一个数据表student(No, Name, Sex, Age, Dept...

Question

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

A. 查询所有14岁到18岁之间的男学生，并输出他们的姓名和年龄：<br>Select Name, Age From<br>student Where sex = &lsquomale&rsquo and age between 14 and 18

B. 查询所有姓名包含&ldquo妍&rdquo的学生：<br>Select * From student<br>Where name like &ldquo_妍%&rdquo

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

D. 统计表中不同系别的男生的平均年龄，并按从大到小排列：<br>Select Dept, avg(Age)<br>From student Where sex = &lsquomale&rsquo Group by Dept Order by avg(Age)