Aggregate functions and data types
Aggregate functions are another valuable tool for the SQL programmer. They are used extensively across businesses to calculate important metrics, such as the average cost of making a film.
You know five different aggregate functions:
-AVG()
-SUM()
-MIN()
-MAX()
-COUNT()
Test your knowledge of what data types they are compatible with.
This exercise is part of the course
Intermediate SQL
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
