What organization id Denesik and Sons Party?
select organization_id from organizations where organization_details = 'Denesik and sons Party'
What are the service type code of service id 10?
select service_type_code from services where service_id = '10'
What organization details of service id 11?
select t2.organization_details from services as t1 join organizations as t2 on t1.organization_id = t2.organization_id where t1.service_id = '11'
What is the distinct service type 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'