select class_name as 'CLASS', person_name as 'PERSON', amt as 'HOUSEHOLDS'
from (select *, dense_rank() over (partition by class_name order by amt desc) as rank
from household
where person_code != 1 and class_code != '01')
where rank = 1
order by class;