select
CLASS_NAME as CLASS,
PERSON_NAME as PERSON,
AMT as HOUSEHOLDS
from HOUSEHOLD H1
where 
   PERSON_CODE != '1'
   and CLASS_CODE != '01'
   and not exists (
    select * from HOUSEHOLD H2 
    where H1.CLASS_NAME = H2.CLASS_NAME
    and H1.AMT < H2.AMT 
    and   H2.PERSON_CODE != '1'
   and H2.CLASS_CODE != '01'
   )
order by 
CLASS_CODE