数据库练习

最新推荐文章于 2025-03-01 01:17:25 发布

david___

最新推荐文章于 2025-03-01 01:17:25 发布

阅读量107

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/david___/article/details/102681323

版权

MySQL 专栏收录该内容

6 篇文章

订阅专栏

题目见https://blog.csdn.net/csdnluolei/article/details/83507312

--3、查询平均成绩大于等于60分的同学的学生编号和学生姓名和平均成绩

SELECT
	a.s_id,
	a.s_name,
	b.avg_score 
FROM
	Student a
	LEFT JOIN (
SELECT
	s_id,
	round( AVG( s_score ), 1 ) AS avg_score 
FROM
	Score 
GROUP BY
	s_id 
	) b ON a.s_id = b.s_id 
WHERE
	b.avg_score > 60 
ORDER BY
	b.avg_score DESC