select
CLASS_NAME as CLASS,
PERSON_NAME as PERSON,
MAX(AMT) as HOUSEHOLDS
from
HOUSEHOLD as test1
left outer join 
(
select
MAX(AMT) as HOUSEHOLDS
from
HOUSEHOLD
where
CLASS_CODE != '01'
and PERSON_CODE != '1'
) as test2
on test1.AMT = test2.HOUSEHOLDS
where
CLASS_CODE != '01'
and PERSON_CODE != '1'
group by
CLASS_CODE
order by
CLASS