We can sort data in more than the ascending order (this is the default sort order). The ORDER BY clause can sort the data in descending order. To do this, we need to specify the keyword DESC.
Let's look at an example.

SELECT continent 
FROM country 
ORDER BY continent DESC;


 **Sort Descending Multiple Columns**

We can sort the data by more than one column. In fact, it is often necessary to sort data by more than one column. For example, if we display a list of students, we may want to display it sorted by the last name and first name. This type of sorting should be used if several students have the same last name.
If we are sorting descending on multiple columns, we ensure each column has its own DESC keyword.
Let's see an example.

SELECT id, name, region FROM country ORDER BY region , name DESC;

**Explanation:** The DESC keyword only needs to be applied to the name of the column we want to sort in kill order. In our example, DESC was specified for the `name` column, but not for the `region` column. Therefore, the `name` column is sorted in descending order, but the `region` column is sorted in ascending order (ascending order is the default).

In this section, we will learn how to use the SQL SELECT statement to get a single table column, multiple table columns, and all table columns. We will also find out how to return unique values.

In this section, we will learn how to sort retrieved data using the ORDER BY clause. This clause, which must be the last in the SELECT statement, can be used to sort data on one or more columns as needed.\n

In this section, we will learn how to filter returned data using the SELECT statement’s WHERE clause. We will learn how to test for equality, inequality, more and less significant than value ranges, and NULL values.

In this section, we will learn how to combine WHERE clauses with the AND and OR operators. We will also find out how the NOT operator works.\n\n\n

In this section, we will learn what the SQL aggregate functions are and how to use them to summarize table data.