Difference between order by/group by

Hi

Can anyone elaborate or rephrase the explanation about the problem below?

Thanks!


https://www.codecademy.com/paths/data-science/tracks/sql-intermediate/modules/dspath-sql-aggregates/quizzes/learn-sql-aggregate-functions-sql-quiz-3

1 Like

GROUP BY refers to column headings in the new table, ORDER BY is the sort order of the column.

When there all multiple columns we can sort by one column, then by another column if we so wish.

1 Like