sql average cost code example
Example 1: sql average
SELECT student_name, avg(notes) FROM student_notes GROUP BY student_name;Example 2: average salary in sql
SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY = (SELECT AVG(SALARY) FROM EMPLOYEES);SELECT student_name, avg(notes) FROM student_notes GROUP BY student_name;SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY = (SELECT AVG(SALARY) FROM EMPLOYEES);