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