The output code learning in the textbox

CodePudding user response:

Should be a job, so we will not provide a complete answer

Only provide your direction, baidu "SQL query son" "SQL case count", "SQL aggregation window function
"
If they are hiring,
Son write SQL query -- -- -- -- -- -- -- -- -- --
to 60 pointsWrite SQL case iif -- -- -- -- -- -- -- -- -- to 80
Write SQL aggregation window function -- -- -- -- -- -- -- -- -- to 90

Of course score itself is not important, where the only represent you master, at the very least, can see that you spend no effort at ordinary times

CodePudding user response:

Select a case when score> 0 and score<60 count (*) the when score> 70 and score<80 the count (*)... End the from the table