What does the SQL function 'COUNT()' do?Computes the average of numeric valuesCounts the number of rows in a result setRetrieves distinct values from a columnFinds the maximum value in a column

The COUNT function in SQL is used for:Calculating the average of a numeric column.Finding the maximum value in a column.Counting the number of rows in a table or within a group.pen_sparkAdding all the values in a numeric column.

Which SQL function is used to calculate the average value of a numeric column?OptionsMAX()SUM()COUNT()AVG()

Which SQL function is used to count the number of rows in a SQL query?COUNT()NUMBER()SUM()COUNT(*)

Which SQL function is used to find the number of rows in a table?OptionsMAX()SUM()COUNT()AVG()

Which SQL function can be used to count the number of rows in a GROUP BY clause?COUNT()SUM()AVG() MAX()