COUNT is the only aggregate function listed that works with all data types (numeric, character, date). AVG, SUM, and STDDEV are mathematical functions that only work with numeric data. COUNT(*) counts rows, while COUNT(expression) counts non-null values regardless of data type.