Student's Average Score

Problem Statement

Student's Average Score You are given a table students that stores the marks obtained by students across multiple subjects. Each row represents one student's score in one specific subject. Write an SQL query that calculates the average score of each student across all the subjects that student has a row for , and returns the results ordered by student_id . Table: students Column Data Type Description student_id INTEGER Represents the unique id of the student name VARCHAR Represents the name of the student subject VARCHAR Represents the subject name score INTEGER Represents the marks obtained in the subject The pair (student_id, subject) is unique: a student has at most one row per subject. All rows of one student_id carry the same name . Two different students may have the same name. Students do not all take the same subjects, and they do not all take the same number of subjects. Expected Output Return the following columns, in this order: Column Description student_id Unique id of the