SQL AVG

SELECT 
姓名=(SELECT MName FROM dbo.Member WHERE MID = dbo.Score.MID),
平均分=(SELECT AVG(Score) FROM dbo.Score)
FROM dbo.Score 
GROUP BY MID 
ORDER BY 平均分 DESC,姓名

SQL AVG

标签：