Aggregate functions AVG, SUM, COUNT, MAX, MIN are aggregate functions in SQL. They can be applied to any column of a table. They can be used in select clause of SQL queries. They always discard NULL values, only coun(*) takes into consideration NULL values. Contributor's Info Created: 0Comment thumbs up down up1 like.