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;