GROUP BY with Aggregate Functions



SELECT Product_Category,
       MIN(UnitPrice) AS Lowest_UnitPrice,
       MAX(UnitPrice) AS Highest_UnitPrice,
       SUM(UnitPrice) AS Total_UnitPrice,
       AVG(UnitPrice) AS Average_UnitPrice
FROM Dummy_Sales_Data_v1
GROUP BY Product_Category