select t.bj,t.语文,b.数学 from ;
(select bj, count(yw) as 语文 from cj where yw > 90 group by bj) t ;
left join ;
(select bj, count(sx) as 数学 from cj where sx > 90 group by bj) b ;
on t.bj = b.bj
sele bj,count(yw),count(sx) from cj where yw>=90 and sx>=90 group by bj
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024