select
    h.CLASS_NAME AS CLASS,
    h.PERSON_NAME AS PERSON,
    h.AMT AS HOUSEHOLDS
from HOUSEHOLD h
left join (
    select
        CLASS_NAME AS CLASS_NAME,
        max(AMT) as max_amt
    from HOUSEHOLD
    where PERSON_CODE != '1' and CLASS_CODE != '01'
    group by CLASS_NAME
) tmp ON tmp.CLASS_NAME = h.CLASS_NAME and tmp.max_amt = h.AMT
where h.PERSON_CODE != '1' and h.CLASS_CODE != '01' and tmp.CLASS_NAME is not null
order by h.CLASS_CODE