Sorting by Multiple Columns

For example, to sort person by their first names in ascending order and their last names in descending order, you use the following statement:

SELECT
	first_name,
	last_name
FROM
	person
ORDER BY
	first_name,
	last_name DESC;