SELECT
    CLASS_NAME AS CLASS
    ,CASE WHEN MAX(AMT) THEN PERSON_NAME END AS PERSON
    ,MAX(AMT) AS HOUSEHOLDS
FROM
    HOUSEHOLD
WHERE
    PERSON_CODE != "1"
    AND
    CLASS_CODE != "01"
GROUP BY 1
ORDER BY CLASS_NAME;