What are some SQL aggregates and other built-in functions? The common aggregate, built-in functions are AVG, SUM, MIN, MAX, COUNT and DISTINCT.