初学高手请进

Question

select 姓名,sum(成绩) from 表 group by 姓名 having sum(成绩) > 270

Answer 1

select 姓名,总分=sum(成绩) from 表 group by 姓名 having sum(成绩)>270

Answer 2

select 姓名,sum(成绩) as 总分 from 表 group by 姓名 having sum(成绩) > 270

Answer 3

select 姓名,sum(成绩) as 总分 from 表 group by 姓名 having sum(成绩) > 270

Answer 4

select 姓名, sum(成績) as 總分  from 表 group by 姓名 having sum(成績)> 270