WITH a as (
    SELECT
        distinct 
         CLASS_CODE
        ,max(AMT) OVER (partition by CLASS_CODE) as maxAMT
    FROM
        HOUSEHOLD
    WHERE
        PERSON_CODE <> '1'
    and CLASS_CODE <> '01'
    
)
SELECT
    t2.CLASS_NAME as CLASS
    ,t2.PERSON_NAME as PERSON
    ,t2.AMT as HOUSEHOLDS
FROM
    a t1
inner join HOUSEHOLD t2 on t1.CLASS_CODE = t2.CLASS_CODE
and t2.AMT = t1.maxAMT
and t2.PERSON_CODE <> '1'
and t2.CLASS_CODE <> '01'

ORDER BY t2.CLASS_CODE ASC