Show me the names of all the physicians?
select name from physician
Show me the ssn of the physician named John Dorian?
select ssn from physician where name = 'John Dorian'
Show me the name of the physician with employee id 2?
select name from physician where employeeid = 2
Show me the names of the physician who prescribed the highest dose?
select t1.name from physician as t1 join prescribes as t2 on t1.employeeid = t2.physician order by t2.dose desc limit 1