avg function sql code example

Example 1: sql average

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

Example 2: sql avg()

/*AVG() is an aggregate function that returns the 
   average value for a numeric column*/
SELECT AVG(column_name)
FROM table_name;