ORDER BY

1. SELECT author_lname FROM books;
2.  
3. SELECT author_lname FROM books ORDER BY author_lname;
4.  
5. SELECT title FROM books;
6.  
7. SELECT title FROM books ORDER BY title;
8. SELECT author_lname FROM books ORDER BY author_lname DESC;
9.  
10. SELECT released_year FROM books;
11.  
12. SELECT released_year FROM books ORDER BY released_year;
13.  
14. SELECT released_year FROM books ORDER BY released_year DESC;
15.  
16. SELECT released_year FROM books ORDER BY released_year ASC;
17.  
18. SELECT title, released_year, pages FROM books ORDER BY released_year;
19.  
20. SELECT title, pages FROM books ORDER BY released_year;
21.  
22. SELECT title, author_fname, author_lname
23. FROM books ORDER BY 2;
24.  
25. SELECT title, author_fname, author_lname
26. FROM books ORDER BY 3;
27.  
28. SELECT title, author_fname, author_lname
29. FROM books ORDER BY 1;
30.  
31. SELECT title, author_fname, author_lname
32. FROM books ORDER BY 1 DESC;
33.  
34. SELECT author_lname, title
35. FROM books ORDER BY 2;
36.  
37. SELECT author_fname, author_lname FROM books
38. ORDER BY author_lname, author_fname;