SELECT AVG(column_name) FROM table_name WHERE condition;
SELECT FIRST_NAME FROM EMPLOYEES WHERE SALARY = (SELECT AVG(SALARY) FROM EMPLOYEES);
SELECT student_name, avg(notes) FROM student_notes GROUP BY student_name;