In instances when you want to sort and group,it is appropriate to use only the GROUP BY clause because the DBMS will automatically sort the results by the grouping columns.

Question

Quizplus · Accepted Answer

While the GROUP BY clause groups rows that have the same values in specified columns into summary rows, it does not guarantee that the results will be sorted by the grouping columns unless explicitly stated with an ORDER BY clause. Some DBMS might return sorted results as a side effect of the grouping process, but this behavior is not guaranteed across all systems or scenarios.

In Instances When You Want to Sort and Group,it Is