sql server group by with avg from other table code example

Example: sql avg group by

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