​SELECT tr.name,pat.first_name,pat.last_name
from therapy th
join treatment tr on th.treatment_type=tr.type
join patient pat on th.patient_id=pat.id
join physician ph on th.physician_id=ph.id
where ph.last_name in ('Core','Calderwood')
and mod(pat.id,2)=1