Aggregate and Scalar functions are in built function for counting and calculations. Aggregate functions operate against a group of values but returns only one value. AVG(column):- Returns the average value of a column COUNT(column):- Returns the number of rows (without a NULL value) of a column COUNT(*):- Returns the number of selected rows MAX(column):- Returns the highest value of a …