select
     H.class_name as CLASS ,H.person_name as PERSON , I.amt as HOUSEHOLDS
    from (
    select person_code , class_code , amt
    from HOUSEHOLD
    where PERSON_CODE != 1 and CLASS_CODE != '01'
    group by  class_code
    having max(amt) = amt
    ) as I
    inner join HOUSEHOLD as H on H.person_code = I.person_code and H.class_code = I.class_code 
order by I.class_code