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_CODE
HAVING MAX(AMT) = AMT 
ORDER BY
    CLASS_CODE ASC;