The number of students in the class is greater than 10, the number of students in the class is greater than 50, the number of students in the computer school, and the average number of students in the class is from high to low.

/* Table scores has four fields: Student Stu, class, school institute, and score.
Returned results: the number of students in the class is greater than 10, the number of students in the class is higher than 50, and the average score of the Computer College and the class is from high to low.
You can use any database to write SQL statements. The returned fields are class and the average score is. */

-- Nesting statements are not allowed.
Select top 10 class, average score = AVG (score) from TB
Where Institute = 'computer Emy'
Group by class
Having count (1)> = 10 and min (score)> = 50
Order by AVG (score) DESC