CREATE TABLE services (service_type_code VARCHAR, organization_id VARCHAR)
CREATE TABLE organizations (organization_id VARCHAR, organization_details VARCHAR)

What is 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'
SELECT DISTINCT "T1"."service_type_code" FROM "services" AS "T1" JOIN "organizations" AS "T2" ON "T1"."organization_id" = "T2"."organization_id" AND "T2"."organization_details" = 'Denesik and Sons Party'