select
     CLASS
    ,PERSON
    ,HOUSEHOLDS
from
(
select
     main.CLASS_NAME as CLASS
    ,main.CLASS_CODE as CLASS_CODE
    ,main.PERSON_NAME as PERSON
    ,main.AMT as HOUSEHOLDS
    ,row_number() over(partition by main.CLASS_CODE order by main.AMT desc) as rank
from
    HOUSEHOLD as main
where
    ifnull(main.PERSON_CODE, '') <> '1' and ifnull(main.CLASS_CODE, '') <> '01' and main.AMT is not null
--    ifnull(main.PERSON_CODE, '') = '1' or ifnull(main.CLASS_CODE, '') = '01'
)
where
    rank = 1
order by
     CLASS_CODE asc