Perform Conditional Aggregation for Dashboard Metrics

SELECT
    COUNT(*) AS total_orders,
    SUM(CASE WHEN status = 'pending' THEN 1 ELSE 0 END) AS pending_orders,
    SUM(CASE WHEN status = 'completed' THEN 1 ELSE 0 END) AS completed_orders,
    SUM(CASE WHEN order_amount > 100 THEN 1 ELSE 0 END) AS high_value_orders
FROM Orders;

How it works: This snippet demonstrates conditional aggregation, allowing you to calculate multiple counts or sums based on different criteria within a single SELECT statement. By using CASE expressions inside SUM() or COUNT(), you can effectively categorize and aggregate data for various metrics, such as counting pending, completed, or high-value orders from the Orders table, making it ideal for dashboard reporting.