Which among the following belongs to an "aggregate function"?

Solution (By Examveda Team)

This question is about aggregate functions in MySQL. Aggregate functions are special functions that work with groups of rows in your database table. They summarize data to give you a single value for each group.
Let's look at the options:
Option A: COUNT
This function counts the number of rows in a table or a specific column. It's an aggregate function because it combines multiple rows into a single count value.
Option B: UPPER
This function converts all the letters in a string to uppercase. It's not an aggregate function because it works on individual values within a single row, not on groups of rows.
Option C: LOWER
Similar to UPPER, this function converts all the letters in a string to lowercase. It also works on individual values and is not an aggregate function.
Option D: All of the mentioned
This option is incorrect because only COUNT is an aggregate function.
Therefore, the correct answer is Option A: COUNT.