/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

1 vote309 views3 answers
Update from select sqlite
SQL
1 vote292 views1 answer
Mysql history command
SQL
2 votes309 views1 answer
Sql get the name of user pc
SQL
0 vote336 views1 answer
How to make sure two tables have same exact data in sql
SQL
-1 vote285 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
-1 vote309 views4 answers
Restart mysql server ubuntu
SQL
3 votes309 views1 answer
Sql set null
SQL
0 vote343 views2 answers
Impala rename column name
SQL
3 votes299 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
1 vote297 views1 answer
Change table to innodb mysql
SQL