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"
Find the name and position of physicians who prescribe some medication whose brand is X?
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 ''
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 = value
Find the name and position of physicians who prescribe some medication whose brand is X ?