SELECT
CLASS_NAME AS CLASS,
PERSON_NAME AS PERSON,
AMT AS HOUSEHOLDS
FROM
HOUSEHOLD
WHERE 
PERSON_CODE IS NOT '1'
AND
CLASS_CODE IS NOT '01'
GROUP BY CLASS
HAVING MAX(HOUSEHOLDS)
ORDER BY CAST(CLASS_CODE as UNSIGNED)  ASC;