SQL

Aggregating Data with GROUP BY and SUM/COUNT

Summarize and group data using SQL's GROUP BY clause with aggregate functions like SUM, COUNT, and AVG for powerful analytical insights.

SELECT
  category_name,
  COUNT(product_id) AS total_products,
  SUM(price * stock_quantity) AS total_category_inventory_value
FROM
  products
GROUP BY
  category_name
HAVING
  COUNT(product_id) > 5
ORDER BY
  total_products DESC;

How it works: This snippet demonstrates how to aggregate data using the `GROUP BY` clause with aggregate functions. It groups products by their `category_name` and then calculates the total number of products (`COUNT`) and the total inventory value (`SUM`) for each category. The `HAVING` clause allows filtering on the aggregated results, showing only categories with more than 5 products. This is fundamental for generating reports and summaries, providing valuable insights into dataset distributions.

Aggregating Data with GROUP BY and SUM/COUNT

Need help integrating this into your project?