Retrieve all the first and last names of authors in the alphabetical order of last names.
CREATE TABLE authors (fname VARCHAR, lname VARCHAR)
SELECT fname, lname FROM authors ORDER BY lname
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE authors (fname VARCHAR, lname VARCHAR) Question: Retrieve all the first and last names of authors in the alphabetical order of last names. [/INST] SELECT fname, lname FROM authors ORDER BY lname </s>