CASE: Create Price Tiers

Use CASE expressions to categorize tracks into pricing tiers. CASE acts like if-then-else logic within SQL.

Write a query that categorizes tracks as 'Standard' ($0.99) or 'Premium' ($1.99) based on their price.

Schema: Track

Requirements:

• Use CASE to create a PriceTier column
• $0.99 = 'Standard', $1.99 = 'Premium', anything else = 'Other'
• Return track Name, UnitPrice, and PriceTier
• Order by UnitPrice descending (so Premium tracks appear first), then by TrackId ascending to break ties
• Limit to the first 20 rows

CASE Syntax:

CASE
    WHEN condition1 THEN result1
    WHEN condition2 THEN result2
    ELSE default_result
END