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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Retrieve all the first and last names of authors in the alphabetical order of last names. ### Input: CREATE TABLE authors (
    fname VARCHAR,
    lname VARCHAR
) ### Response: SELECT fname, lname FROM authors ORDER BY lname