what are aggregate function in dbms code example

Example 1: what are the aggregate function in sql

--- GROUP FUNCTION | MULTI ROW FUNCTION | AGGREGATE FUNCTION 
--- COUNT , MAX , MIN , SUM , AVG

Example 2: how to use aggregate functions in sql

This is the example.Aggregate function is AVG.production.products is the table.

SELECT
    AVG(list_price) avg_product_price
FROM
    production.products;