Question

怎么查出总成绩大于100的学生，列出学生编号，总成绩 SQL语句该怎么写啊？

表名student
id course score
001 数学 60
001 语文 60
002 数学 30
002 语文 30
查出结果如下：id score
001 120

Answer 1

select id,sum(score) as score from student group by id having sum(score)>100

Answer 2

select id ,score from (select id,sum(score) as score from student group by id) where score>100

Answer 3

select id,sum(score) score from student group by id having sum(score)>100

Answer 4

select id,sum(score) as score from student group by id having sum(score)>100