Sql functions for aggregation

Data Science, AI and ML
#1

SQL FUNCTIONS FOR AGGREGATION
In SQL, there are five important aggregate functions for data analysts/scientists:
• COUNT()
• SUM()
• AVG()
• MIN()
• MAX()
A few examples:
SELECT COUNT(*) FROM table_name WHERE column1 = ‘something’;
It counts the number of rows in the SQL table in which the value in column1 is
‘something’.
SELECT AVG(column1) FROM table_name WHERE column2 > 1000;
It calculates the average (mean) of the values in column1, only including rows in
which the value in column2 is greater than 1000.