All you need to know about GROUP BY Clause

What is group by clause in sql and when does Group by clause used in sql?