What is the use of GROUP BY clause?

The GROUP BY clause combines all those records that have identical value in a particular field or a group of fields.

SELECT ItemName, Sum(QtySold)
FROM Order
WHERE OrderDate = current_date()
GROUP BY ItemName;