The AVG() function returns the average value of a numeric column.

SELECT AVG(column_name)
FROM table_name
WHERE condition;

NULL values are ignored

Higher than average

SELECT * FROM Products
WHERE price > (SELECT AVG(price) FROM Products);