What are all the different parent organization ids?
select distinct parent_organization_id from organizations
How many organizations are their own parent?
select count(*) from organizations where parent_organization_id = organization_id
Which organizations are not a parent to any others?
select organization_id from organizations except select parent_organization_id from organizations