Question

If the data returned by the GROUP BY clause needs to be sorted in descending order, you must include a(n) ____________________ clause in the SELECT statement.

A) ORDER BY DESC
B) SORT DESC
C) DESCENDING
D) ORDER DESC

Answer 1

To sort group by data in descending order, include an ORDER BY clause along with DESC keyword in the SELECT statement.

Step-by-step explanation:

When you need the data returned by the GROUP BY clause to be sorted in descending order, you should include an ORDER BY clause followed by the column name and DESC keyword in the SELECT statement. For example, if you’re grouping sales data by region and want to sort the summed sales in descending order, your SQL query might look something like this:

SELECT region, SUM(sales)
FROM sales_data
GROUP BY region
ORDER BY SUM(sales) DESC;

This will group the sales by region and then order the results in descending order based on the total sales.