#11 AGGREGATION FUNCTIONS (SQL AF SOMALI) DATABASE MANAGEMENT SYSTEM

#SOMALI_INSTITUTE_OF_TECHNOLOGY
#SIT
-AGGREGATE FUNCTIONS: performs a calculation on a set of values and returns a single value
-We often use aggregate functions with the GROUP BY and HAVING clauses of the SELECT statement
-AVG – calculates the average of a set of values
-COUNT – counts rows in a specified table or view
-MIN – gets the minimum value in a set of values
-MAX – gets the maximum value in a set of values
-SUM – calculates the sum of values

• #science_technology
• #somali_institute_of_technology
• #sit
• #11_aggregation_functions_sql_af_somali_database_management_system