standard sql average code example

Example 1: sql average

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

Example 2: how to find average in sql

SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY = (SELECT AVG(SALARY) FROM EMPLOYEES);