Simple CASE WHEN Classification
Easy
case-when
Netflix
Spotify
Coinbase
Write a query to classify products by price range: 'Budget' (< 50), 'Mid-Range' (50-200), 'Premium' (> 200). Return name, price, and price_tier, ordered by price.
Expected Output: Products classified into price tiers.
Tables
Hints (2 available)
SQL Editor
Output
Click "Run" to see results...