当前位置：网站首页>The query that the user's test score is greater than the average score of a single subject

The query that the user's test score is greater than the average score of a single subject

2022-08-05 10:17:00 【go and be safe~】

Such a situation is often encountered in life. For example, in the grades of the whole class, we want to count the situation that each student's single subject score is above the average score of the subject in the class, and display it..

The case is as follows:

After each exam, there will be a grade sheet, as follows:

idjobscore
1C++11001
2C++10000
3C++9000
4Java12000
5Java13000
6JS12000
7JS11000
8JS9999
9Java12500

Please write a sql statement to query the attributes of all grades whose user's score is greater than the average score of their job (job), and sort them in ascending order of id, as follows:

Incorrect spelling:

select g.id,g.job,g.score from grade g
left join
(select job,avg(score) as A from grade group by job) f

原网站

版权声明
本文为[go and be safe~]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/217/202208051010493887.html

边栏推荐

猜你喜欢

随机推荐