What is the id of the parent organization to the 'Robel-Schulist Group'?
select parent_organization_id from organizations where organization_details = 'Robel-schulist Group'
What is the detail of this organization id?
select organization_details from organizations where organization_id = (select parent_organization_id from organizations where organization_details = 'Robel-schulist Group')
What are the distinct service types that are provided by the organization which has detail 'Denesik and Sons Party'?
select distinct t1.service_type_code from services as t1 join organizations as t2 on t1.organization_id = t2.organization_id where t2.organization_details = 'Denesik and sons Party'