/SQL/How to use aggregate functions in sql

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;

Source: sqlservertutorial.net

Aggregate function in sql

• Single Row Functions:(Lower, Upper, Substr, Length)
function that will run for each row and 
return value for each row.

Multiple Row Functions (Group functions, Aggregate functions):
(Count, MIN , MAX, AVG, SUM)
will run for multiple rows and return a single value

Similar codes

0 vote117 views1 answer
Mysql sql select one day before
SQL
0 vote74 views1 answer
Sql truncate table referencing itself
SQL
0 vote137 views1 answer
Postgresql inheritance
SQL
0 vote123 views1 answer
Sql remove last 2 digit
SQL
0 vote118 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
9 votes121 views4 answers
How to create new user and database postgresql in ubuntu
SQL
2 votes115 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote127 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote121 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
5 votes114 views1 answer
How to check port number for postgresql
SQL