GROUP BY in SQL is to group rows that share a common value in one or more columns so that you can apply aggregate functions (like AVG(),COUNT(), etc.) on each group separately. Without GROUP BY, aggregate functions will operate on the entire result set,but you only want to calculate the average quantity for each product.