For each subject, return the subject_name and the average score achieved across all Marks records in that subject.
Database
Greenfield High — Student Records
A small school database: students, the subjects they can take, and the marks recorded each term.
Loading in-browser database…
Run your query to see results here.