Top 10 SQL function used in data analyst
- AVG(): Calculate the average value of a column.
+ SELECT AVG(column_name) FROM table_name;
- SUM(): Get the sum of values in a column.
- SELECT SUM(column_name) FROM table_name;
- COUNT(): Count the number of rows or non-null values in a column.
+ SELECT COUNT(column_name) FROM table_name;
- MAX(): Finf the maximum value in a column.
- SELECT MAX(column_name) FROM table_name;
- MIN(): Discover the minimum value in a column.
+ SELECT MIN(column_name) FROM table_name;
- GROUP BY: Group rows based on a specified column.
- SELECT column_name, aggregate_function(column_name) FROM table_name GROUP BY column_name;
- HAVING: Filter grouped rows based on condition.
+ SELECT column_name, aggregate_function(column_name) FROM table_name GROUP BY column_name HAVING condition;