group by vs order by code example

Example 1: group by vs 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.

Example 2: group by vs 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.