SELECT CLASS_NAME AS CLASS
,CASE WHEN MAX(AMT) THEN PERSON_NAME ELSE 0 END  AS PERSON
,AMT AS HOUSEHOLDS
FROM HOUSEHOLD
WHERE 1=1
AND PERSON_CODE<>'1'
AND CLASS_CODE<>'01'
GROUP BY CLASS_CODE,CLASS_NAME
ORDER BY CLASS_CODE asc;