SQL
Perform Conditional Aggregation for Summarized Reports
Generate a summarized report by conditionally counting or summing values based on specific criteria within a single SQL query using CASE statements.
SELECT
product_category,
COUNT(CASE WHEN status = 'pending' THEN 1 END) AS pending_orders,
COUNT(CASE WHEN status = 'completed' THEN 1 END) AS completed_orders,
COUNT(*) AS total_orders
FROM orders
GROUP BY product_category;
How it works: This snippet demonstrates conditional aggregation using `CASE` statements inside `COUNT()`. It allows you to count specific conditions (like 'pending' or 'completed' statuses) within different columns for each 'product_category' in a single query, providing a consolidated and insightful summary.