What is the list of the dose each physician prescribes?
select * from physician as t1 join prescribes as t2 on t1.employeeid = t2.physician
Sort in the descending order of dose.
select * from physician as t1 join prescribes as t2 on t1.employeeid = t2.physician order by t2.dose desc
What are 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