SQL statement for average score of Student Course Selection

There is a student table with three columns in total. The first column is the student ID column, which stores the student ID of the Course Selection. You can repeat it to allow one student to select multiple courses.

The second column is the course column, that is, the name of the course selected.

The third column is the score column, that is, the score of the student.

The student table contains the following data:

The SQL statement used to calculate the average score of a student's course selection is as follows:

Select ID, AVG (score) from studentgroup by ID;

Use the AVG function to calculate the average score, that is, the average score. The query conditions are grouped by student ID.

The where condition is not required here.

 

The query result is as follows: