sql查询语句

select * from (select 姓名,sum(工资) as 工资数,sum(奖金) as 奖金数 from 员工表 Group by 姓名) as t order by 工资数
or:
select 姓名,sum(工资) as 工资数,sum(奖金) as 奖金数 from 员工表 Group by 姓名 order by 工资数
or:
select 姓名,sum(工资) as 工资数,sum(奖金) as 奖金数 from 员工表 Group by 姓名 order by sum(工资)