全部评论
Select name, avg(score) From student Group by name Having min(score) >= 80;
送花
回复
分享
select name,avg(score)as score from student group by name having min(score)>80
送花
回复
分享
秋招专场
官网直投
SELECT NAME,AVG(SCORE) FROM STUDENT Group by NAME Having MIN(SCORE) > 80
送花
回复
分享
相关推荐
查看4道真题和解析
点赞 评论 收藏
转发