with tbl as (
select 
    class_code,
    /*class_name as CLASS,*/
    person_name as PERSON,
    max(amt) as HOUSEHOLDS 
from HOUSEHOLD 
where person_code <>'1' and class_code <> '01' 
group by class_code
)
select 
    class_name as CLASS,
    person_name as PERSON,
    tbl.HOUSEHOLDS
from HOUSEHOLD 
inner join tbl 
on tbl.class_code=household.class_code 
and tbl.person=household.person_name;