如题所述
第1个回答 推荐于2021-01-29
select 学号
from 成绩表
group by 学号
having count(*)>3 and avg(成绩)>80本回答被提问者采纳
from 成绩表
group by 学号
having count(*)>3 and avg(成绩)>80本回答被提问者采纳
第2个回答 2011-12-17
select 学号 from 成绩表 group by 学号 having count(*)>3 and avg(成绩)>80
第3个回答 2011-12-19
select 学号
from 成绩表
group by 学号
having count(*)>3 and avg(成绩)>80
from 成绩表
group by 学号
having count(*)>3 and avg(成绩)>80
