SyntaxStudy
Sign Up
Home MySQL Exercises Aggregate Functions

Aggregate Functions

Intermediate

Complete the MySQL aggregate function names.

To count all rows: (*)

To sum a column: (price)

To get the average: (salary)

To get the highest value: (score)

To group results by a column: GROUP category

To filter grouped results: COUNT(*) > 5