What are the names and positions of all physicians who prescribed brand X medications?
select distinct t1.name, t1.position from physician as t1 join prescribes as t2 on t1.employeeid = t2.physician join medication as t3 on t3.code = t2.medication where t3.brand = "X"
What were the dates he prescribed those medications?
select distinct t2.date from physician as t1 join prescribes as t2 on t1.employeeid = t2.physician join medication as t3 on t3.code = t2.medication where t3.brand = "X"
What was the dose of that medication?
select dose from physician as t1 join prescribes as t2 on t1.employeeid = t2.physician join medication as t3 on t3.code = t2.medication where t3.brand = "X"