Why do we use GROUP BY and ORDER BY function in mysql?

Group By is used for retrieving information about a group of data. It is generally used with some aggregate function like SUM, AVG etc.

ORDER BY is used to sort the records using column name. It can sort column in both ascending and descending order.