SELECT author_lname FROM books;

SELECT author_lname FROM books ORDER BY author_lname;

SELECT title FROM books;

SELECT title FROM books ORDER BY title;
SELECT author_lname FROM books ORDER BY author_lname DESC;

SELECT released_year FROM books;

SELECT released_year FROM books ORDER BY released_year;

SELECT released_year FROM books ORDER BY released_year DESC;

SELECT released_year FROM books ORDER BY released_year ASC;

SELECT title, released_year, pages FROM books ORDER BY released_year;

SELECT title, pages FROM books ORDER BY released_year;

SELECT title, author_fname, author_lname 
FROM books ORDER BY 2;

SELECT title, author_fname, author_lname 
FROM books ORDER BY 3;

SELECT title, author_fname, author_lname 
FROM books ORDER BY 1;

SELECT title, author_fname, author_lname 
FROM books ORDER BY 1 DESC;

SELECT author_lname, title
FROM books ORDER BY 2;

SELECT author_fname, author_lname FROM books 
ORDER BY author_lname, author_fname;