pymysql查询操作

利用视图查询平均score最低的sname以及该sname拥有的最高的score

SELECT sc.sid,s.sname,max(sc.score) maxscore
FROM `sc_xxx` sc
left join `s_xxx` s on s.sid=sc.sid
group by sid 
order by avg(score) limit 1

select a.sname
,a.max_score
from
(
select t1.sname
,avg(t.score) avg_score
,max(t.score) max_score
from sc t
join s t1
on t.sid =t1.sid
group by t1.name
order by avg(t.score )
) a
where rownum= 1;

您好，我是有问必答小助手，您的问题已经有小伙伴帮您解答，感谢您对有问必答的支持与关注！
PS：问答VIP年卡 【限时加赠：IT技术图书免费领】，了解详情>>> https://vip.csdn.net/askvip?utm_source=1146287632