sql avg function code example

Example 1: sql avg()

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

Example 2: how to find average in sql

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