pyMySQL视图操作

Question

怎么查找出平均score 最高的sid对应的sname与该sid对应的最低的 score以及对应的cid

Answer 1

select s.sname,
(select cid from sc_xxx where sid =t.sid ORDER BY score limit 1) cid 
from s_xxx s,
(select sid,avg(score) from sc_xxx GROUP BY sid order by avg(score) desc limit 1) t
where s.sid=t.sid