We can obtain the number of each class, but also to the number of the more than 80 points in each class,

But how to calculate the number of each pan chao over 75% are in more than 80 points?

CodePudding user response:

Need to use sub queries