group by and order by differnce. code example
Example: difference between group by and order by
GROUP BY: is used to collaborate
with the SELECT statement to arrange
matching data into groups.
ORDER BY: is for sorting result
either in descending or ascending order.