sql学习，用join替换in

查询学生平均分大于60分的
in 方法

SELECT
	a.s_name,ROUND(AVG( b.s_score ),2) from student a
	JOIN score b ON a.s_id = b.s_id 
	group BY a.s_id,a.s_name 
HAVING
	AVG( b.s_score )> 60

join方法

	select b.s_id,b.s_name,ROUND(AVG(a.s_score),2) as avg_score from 
    student b 
    join score a on b.s_id = a.s_id
    GROUP BY b.s_id,b.s_name HAVING ROUND(AVG(a.s_score),2)>=60;

---

-END-

如果你喜欢我的分享，欢迎关注微信公众号 java学长分享技术干货！

悄悄告诉你免费赠送重磅互联网架构师教程，提升职场技术水平！