select HH.class_name as CLASS, HH.person_name as PERSON, HH.amt as HOUSEHOLDS
from HOUSEHOLD as HH
where HH.person_code <> '1' and HH.class_code <> '01'
group by HH.class_code
having max(HH.amt)
order by HH.class_code asc;