Which of the following are SQL aggregate functions?1) COUNT2) SUM3) AVG4) MAXQuestion 15Select one:a.2,3,4b.3,4,1c.1,2,3,4d.2,1,3

To determine which of the options contains SQL aggregate functions, we need to identify the aggregate functions from the list provided:

1. COUNT: Counts the number of rows that match a specified criterion.
2. SUM: Calculates the total sum of a numeric column.
3. AVG: Computes the average of a numeric column.
4. MAX: Returns the maximum value in a set.

SQL Aggregate Functions

All the listed functions (COUNT, SUM, AVG, MAX) are SQL aggregate functions.

Evaluation of Options

Now we evaluate the provided options:

1. Option a: 2, 3, 4 (SUM, AVG, MAX)

   • Functions included: SUM, AVG, MAX (All aggregate functions)

2. Option b: 3, 4, 1 (AVG, MAX, COUNT)

   • Functions included: AVG, MAX, COUNT (All aggregate functions)

3. Option c: 1, 2, 3, 4 (COUNT, SUM, AVG, MAX)

   • Functions included: COUNT, SUM, AVG, MAX (All aggregate functions)

4. Option d: 2, 1, 3 (SUM, COUNT, AVG)

   • Functions included: SUM, COUNT, AVG (All aggregate functions)

Conclusion

Since all options contain only aggregate functions, the correct answer is:

Final Answer

c. 1, 2, 3, 4