JOIN semantic_ecommerce.orders AS o ON c.c_custkey = o.o_custkeyJOIN Employee AS T2 ON T1.employee_id = T2.idJOIN policy_clause AS pc ON ip.policy_number = pc.policy_numberJOIN DoctorDetails AS T2 ON T1.DoctorID = T2.DoctorIDJOIN products AS p ON o.product_id = p.product_idJOIN HospitalData AS HD ON DD.DoctorID = HD.DoctorIDINNER JOIN has_pet AS T2 ON T1.stuid = T2.stuidJOIN insurance_application AS ia ON ip.application_number = ia.application_numberINNER JOIN takes AS T2 ON T1.ID = T2.IDJOIN Artist AS T2 ON T1.ArtistId = T2.ArtistId