with t as (select trustee_id, count(*) as org_count
from charity_ccewcharitytrustee cc 
where linked_charity_number = 0
	and individual_or_organisation = 'O'
group by trustee_id),
t_name as (select distinct on(trustee_id) trustee_id, trustee_name
from charity_ccewcharitytrustee)
select trustee_name as "Trustee name", org_count as "Number of charities"
from t inner join t_name on t.trustee_id = t_name.trustee_id
order by org_count desc 
limit 100

select org_count,
	count(*) filter(where individual_or_organisation = 'P') as trustee_count_individual,
	count(*) filter(where individual_or_organisation = 'O') as trustee_count_organisation,
	count(*) as trustee_count
from (
select trustee_id, individual_or_organisation, count(*) as org_count
from charity_ccewcharitytrustee cc 
where linked_charity_number = 0
group by trustee_id, individual_or_organisation
) as a
group by org_count
order by org_count asc