select * from teacher order by 性别，姓名 Desc；sql语句中，不写降序，就是默认升序，所以性别不用谢asc
select * from teacher order by 性别,姓名 desc
