The built-in functions associated with GROUP functions in SQL are

1. COUNT function:
returns the count of records that satisfies the condition for each group of records.
Example:
SELECT department, COUNT(*)FROM employees WHERE salary > 25000 GROUP BY department;

2. MAX function:

returns the maximum values from the column for each group of records.
Example:
SELECT department, MAX(salary) FROM employees GROUP BY department;

3. MIN function:

returns the lowest values from the column for each group of records.
Example:
SELECT department, MIN(salary)FROM employees GROUP BY department;

4. AVG function:

returns the average values from the column for each group of records. SELECT AVG(cost) FROM products WHERE category = ‘Clothing’;

5. SUM function:

returns the total values from the column for each group of records.
Example:
SELECT department, SUM(sales)FROM order_details GROUP BY department;

DISTINCT function:

returns the once occurrence of many repeated values from the column for each group of records.
SELECT AVG(DISTINCT cost)FROM products WHERE category = ‘Clothing’;