What is the purpose of the sql avg function when used with group by

MCQ Answer

What is the purpose of the SQL AVG() function when used with GROUP BY?

Topic : Database Fundamentals

A. Calculates the average value for each group of rows

B. Counts the number of rows in each group

C. Filters groups based on a condition

D. Retrieves the maximum value in each group

Correct Answer is :

A. Calculates the average value for each group of rows