with rank1 as(
select
CLASS_NAME as CLASS
,PERSON_NAME as PERSON
,AMT as HOUSEHOLDS
,RANK() OVER ( PARTITION BY CLASS_NAME 
                ORDER BY
                    AMT DESC) AS RANK       
from
HOUSEHOLD
where 
PERSON_CODE != "1"
and
CLASS_CODE != "01")
select
CLASS
,PERSON
,HOUSEHOLDS
from rank1
where 
RANK=1
order by
CLASS asc