Sort order

We can change sort order using the DESC (for descending) and ASC (for ascending) keywords.

Example:

SELECT author, title, price

FROM books

ORDER BY price desc, author

Note: author would still be sorted ascending. DESC only affects the price column.