select
    t1.CLASS_NAME as CLASS
,   H2.PERSON_NAME as PERSON
,   t1.HOUSEHOLDS as HOUSEHOLDS
from
(
    select
        CLASS_CODE
    ,   CLASS_NAME
    ,   max(AMT) as HOUSEHOLDS
    from
        HOUSEHOLD
    where
        PERSON_CODE != '1'
    and CLASS_CODE != '01'
    group by
        CLASS_CODE
    ,   CLASS_NAME
) t1
join
    HOUSEHOLD H2
on
    H2.CLASS_CODE = t1.CLASS_CODE
and H2.AMT = t1.HOUSEHOLDS
order by
    t1.CLASS_CODE