SQL
Count Records Per Category with SQL GROUP BY
Efficiently count the number of items or records within different categories or groups using SQL's GROUP BY and aggregate functions like COUNT.
SELECT
category_name,
COUNT(product_id) AS total_products
FROM
products
GROUP BY
category_name
HAVING
COUNT(product_id) > 5
ORDER BY
total_products DESC;
How it works: This query uses `GROUP BY` to aggregate data based on `category_name`, counting the number of products in each category. The `HAVING` clause then filters these grouped results, showing only categories that contain more than 5 products. The results are ordered to show categories with the most products first.