MAX is a valid aggregate function that returns the maximum value in a group. Group By is not a function but a clause that defines how data is grouped. Is Null is a conditional function, not an aggregate function. Other aggregate functions include SUM, COUNT, AVG, MIN, etc.