SELECT
a.CLASS_NAME as  CLASS,
a.PERSON_NAME as PERSON,
a.AMT as HOUSEHOLDS
FROM
HOUSEHOLD a INNER JOIN
(
select
CLASS_CODE,
MAX(AMT) AS AMT
from
HOUSEHOLD
where
PERSON_CODE <> '1' and CLASS_CODE <> '01'
group by
CLASS_CODE
) sub ON
a.CLASS_CODE = sub.CLASS_CODE AND
a.AMT = sub.AMT