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