select
        CLASS_NAME
        ,PERSON_NAME
        ,MAX(AMT) AS AMT
    FROM 
        HouseHold
    WHERE
        PERSON_CODE <> '1'
    and
        CLASS_CODE <> '01'
    GROUP BY
        CLASS_CODE
    ORDER BY
        CLASS_CODE ASC
    ;