select
h.CLASS_NAME as "CLASS"
,h.PERSON_NAME as "PERSON"
,h.AMT as "HOUSEHOLDS"
from 
HOUSEHOLD h
where h.PERSON_CODE <> '1'
and h.CLASS_CODE <> '01'
group by h.CLASS_NAME
having max(h.AMT)
order by 
h.CLASS_CODE asc