SELECT CLASS_NAME AS CLASS
       ,PERSON_NAME AS PERSON
       ,MAX(AMT) AS HOUSEHOLDS
       
FROM HOUSEHOLD

WHERE 0=0
AND PERSON_CODE <> '1'
AND CLASS_CODE <> '01'

GROUP BY CLASS_CODE
        
ORDER BY CLASS_CODE ASC;

SELECT a.CLASS_NAME AS CLASS
       ,a.PERSON_NAME AS PERSON
       ,AMT AS HOUSEHOLDS
       
FROM (
      SELECT *
            ,row_number() over (partition by CLASS_CODE order by AMT desc) as c
      FROM HOUSEHOLD
      WHERE 0=0
        AND PERSON_CODE <> '1'
        AND CLASS_CODE <> '01'
        ) as a
WHERE a.c = 1

        
ORDER BY CLASS_CODE ASC;