CASE in Aggregation: Count by Category

Use CASE within aggregation functions to count items by category in a single query. Count tracks by price tier without using GROUP BY on the tier.

Write a query that counts how many Standard and Premium tracks exist using CASE inside COUNT/SUM.

Schema: Track

Requirements:

• Count total tracks
• Count Standard tier tracks ($0.99)
• Count Premium tier tracks ($1.99)
• Return a single row with TotalTracks, StandardCount, PremiumCount

CASE in Aggregation Pattern:

SELECT
    SUM(CASE WHEN condition THEN 1 ELSE 0 END) AS ConditionCount
FROM table;