select
h1.class_name CLASS
, h1.PERSON_NAME PERSON
, h1.AMT HOUSEHOLDS
from HOUSEHOLD h1
join (
select
h.class_name
, max(amt) max_amt
from HOUSEHOLD h 
where h.PERSON_CODE != '1' and h.CLASS_CODE != '01'
group by 
h.class_name)a on a.class_name = h1.class_name and a.max_amt = h1.amt
where 
h1.PERSON_CODE != '1' and h1.CLASS_CODE != '01'
order by h1.class_name