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