with
cls_max_households as(
select 
    CLASS_NAME
    ,MAX(AMT) AS AMT
from HOUSEHOLD
where 
    PERSON_CODE != '1'
and CLASS_CODE != '01'
group by 
    CLASS_NAME
)
select 
    L.CLASS_NAME AS CLASS
    ,L.PERSON_NAME AS PERSON
    ,L.AMT AS HOUSEHOLDS
from HOUSEHOLD as L
inner join cls_max_households using(CLASS_NAME, AMT)
order by 
    L.CLASS_CODE
;