In SQL, the functions:
MIN() – returns the minimum value in a set
SUM() – returns the total sum of a numeric column
COUNT() – returns the number of rows (or non-NULL values)
These are all classic aggregate functions, because they:
Take multiple rows as input
Return a single summary value per group (or per table if no GROUP BY is used)
Other categories:
Logical is usually associated with conditions (e.g., AND, OR, NOT), not MIN/SUM/COUNT.
Filtering is done with WHERE or HAVING clauses, not MIN/SUM/COUNT themselves.
System functions typically provide system metadata, timestamps, or environment info (e.g., current user, server name).
Therefore, functions like MIN, SUM, and COUNT are Aggregate functions (A).
CompTIA Data+ Reference (concept alignment):
CompTIA Data+ Official Exam Objectives – Domain on Data Manipulation (using aggregate functions such as COUNT, SUM, MIN, MAX, AVG).
CompTIA Data+ Official Study Guide – SQL section that explicitly lists aggregate functions and their usage in queries.
