where order by and group by code example

Example: 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.