SELECT
    a.CLASS_NAME AS CLASS
    , a.PERSON_NAME AS PERSON
    , a.AMT AS HOUSEHOLDS
FROM
    HOUSEHOLD AS a 
    
INNER JOIN 
(SELECT CLASS_CODE, MAX(AMT) AS MAXAMT FROM HOUSEHOLD WHERE PERSON_CODE != '1' 
    AND CLASS_CODE != '01' GROUP BY CLASS_CODE) AS b
ON a.CLASS_CODE = b.CLASS_CODE AND a.AMT = b.MAXAMT

WHERE

    a.PERSON_CODE != '1' 
    AND b.CLASS_CODE != '01' 
ORDER BY

    a.CLASS_CODE ASC;