average in 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;

Example 3: how to find average in sql

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

Example 4: sample in sql

Using a SAMPLE clause, we can select random rows.
SELECT * FROM table_name SAMPLE(10);