One person chooses more than 2 failed courses SQL statements

(1) To inquire about two students who failed.
Ideas:
1. First use the WHERE clause in conjunction with the conditions of the score<60 to screen out all the failing persons and their failing courses
2. Use the GROUP BY clause to group by name and use the Count function to count the number of failed courses per person
3. Finally, the result of grouping aggregation is filtered by the HAVING clause, and the count statistic result equals 2 students.
Write it down, that's about it.
Select Student,count (*)
From table
where score<60
GROUP BY Student
Having Count (*) =2

(2) The average score of each course in each class is queried

Ideas:
are grouped by class and course, to change the average of class and course

Select Class, Course, AVG (score)
From table
Group BY class, course

One person chooses more than 2 failed courses SQL statements