average sql in table code example Example: sql average SELECT student_name, avg(notes) FROM student_notes GROUP BY student_name;