What is the code of the medication called Thesisin?
select code from medication where name = "Thesisin"
Which physicians prescribe this medication? Tell me the distinct ids.
select distinct t1.physician from prescribes as t1 join medication as t2 on t2.code = t1.medication where t2.name = "Thesisin"
What are the names of the physicians?
select distinct t1.name from physician as t1 join prescribes as t2 on t1.employeeid = t2.physician join medication as t3 on t3.code = t2.medication where t3.name = "Thesisin"