where with aggregate function sql code example
Example 1: SQL Aggregate Functions
MAX – To find the number of the maximum values in the SQL table.
MIN – Number of the minimum values in the table.
COUNT – Get the number of count values in the SQL table.
AVG – Find average values in the SQL table.
SUM – Return the summation of all non-null values in the SQL table.
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;