Task: Text to Code
Input (English): Step 1: For each row in Organizations table, find corresponding rows in Services table and in Things table.
Step 2: find without repetition Services's service_type_code of the results of step 1 whose Things's service_details equals Denesik and Sons Party
Output (English): SELECT DISTINCT T2.service_type_code FROM Organizations AS T1 JOIN Services AS T2 ON T2.organization_id = T1.organization_id JOIN Things AS T3 ON T1.organization_id = T3.organization_id WHERE T3.service_details = "Denesik and Sons Party"