select 姓名,性别,year(date())-year(出生日期) from 表名 order by 性别 asc,year(date())-year(出生日期) asc 还是我来答吧
select 姓名,性别,年龄 from 表名 order by 性别,年龄
select name,sex,age from tb_info order by sex,age esc
