When do you use which in general? Examples are highly encouraged!
I am referring so MySql, but can't imagine the concept being different on another DBMS
ORDER BY shows a field in ascending or descending order. While GROUP BY shows same fieldnames, id's etc in only one output.
ORDER BY
GROUP BY