Sql: how to use the order by clause to sort results?

Example:

Copy Code
SELECT * FROM employees ORDER BY last_name;

The ORDER BY keyword is used to sort the result set based on one or more columns.

Solution:

Copy Code
SELECT * FROM employees ORDER BY department, salary DESC;