sql create average column code example

Example: sql average

SELECT student_name, avg(notes) FROM student_notes GROUP BY student_name;