1.查询年龄在14到18之间的男性的姓名和性别
select Name,Age from student where age between 14 and 18 and sex='男'
2.查询每个部门的女性的平均年龄，降序排序
select Dept,avg(age) age from student where sex='女' group by Dept Order By age desc
未经验证，有问题欢迎评论区指正~
1.查询年龄在14到18之间的男性的姓名和性别
select Name,Age from student where age between 14 and 18 and sex='男'
2.查询每个部门的女性的平均年龄，降序排序
select Dept,avg(age) age from student where sex='女' group by Dept Order By age desc
未经验证，有问题欢迎评论区指正~
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
