What are the names of the physician who prescribed the highest dose?
CREATE TABLE prescribes (physician VARCHAR, dose VARCHAR); CREATE TABLE physician (name VARCHAR, employeeid VARCHAR)
SELECT TOP 1 T1.name FROM physician AS T1 JOIN prescribes AS T2 ON T1.employeeid = T2.physician ORDER BY T2.dose DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE prescribes (physician VARCHAR, dose VARCHAR); CREATE TABLE physician (name VARCHAR, employeeid VARCHAR) Question: What are the names of the physician who prescribed the highest dose? [/INST] SELECT TOP 1 T1.name FROM physician AS T1 JOIN prescribes AS T2 ON T1.employeeid = T2.physician ORDER BY T2.dose DESC </s>