[Solved] difference between order by and sort by

There’s no such thing as “sort by” in SQL. ORDER BY lets you establish the sort order of your result set.

GROUP BY means something entirely different. You should read about that.