SQL
Summarize Data by Group with Basic Aggregations
Generate summary reports using SQL's GROUP BY clause with aggregate functions like SUM, AVG, and COUNT to gain insights into grouped data.
SELECT
category_id,
COUNT(product_id) AS total_products,
SUM(price) AS total_value,
AVG(price) AS average_price
FROM products
GROUP BY category_id
HAVING COUNT(product_id) > 5;
How it works: This query groups products by their `category_id` and calculates key summary statistics for each group: the total number of products, their combined monetary value, and their average price. The `HAVING` clause further filters these aggregated results to display only categories that contain more than 5 products, providing concise, actionable insights.