MAX()

The MAX() function is used to find the maximum value of a column. For example, if you wanted to check the maximum attendance, then you'd use the following query.

xxxxxxxxxx

SELECT MAX(Attendance) FROM Class;