Can you list the highest dose prescribed for any medication? | What information do you want for the prescriptions? Do you want all information or just the dose amount? | I wanted the name of the physician that prescribed the highest dose, but I believe you've already provided that information?
SELECT T1.name FROM physician AS T1 JOIN prescribes AS T2 ON T1.employeeid  =  T2.physician ORDER BY T2.dose DESC LIMIT 1
highest dose prescribed = MAX(dose); name of the physician that prescribed the highest dose requires joining tables physician and prescribes on physician.employeeid = prescribes.physician;