group by sql in join code example

Example: group by in sql

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.