SELECT 
    CLASS_NAME AS CLASS,
    PERSON_NAME AS PERSON,
    AMT AS HOUSEHOLDS
FROM (
    SELECT 
        PERSON_CODE,
        CLASS_CODE,
        CLASS_NAME,
        PERSON_NAME,
        AMT,
        RANK () OVER (partition by CLASS_CODE order by AMT DESC )   AS RNK
    FROM HOUSEHOLD 
    WHERE PERSON_CODE <> '1' AND CLASS_CODE <>'01' ) SUB
WHERE SUB.RNK  = 1
ORDER BY CLASS_CODE ASC