How to Categorize Revenue Using SQL CASE WHEN?

SELECT revenue, CASE WHEN revenue < 1000 THEN 'Low' WHEN revenue BETWEEN 1000 AND 5000 THEN 'Medium' ELSE 'High' END AS revenue_tier FROM sales;

This SQL query categorizes revenue into 'Low', 'Medium', and 'High' tiers based on specified thresholds.

1. Step 1: Select the revenue column from the sales table.
2. Step 2: Use the CASE WHEN statement to define conditions for categorization.
3. Step 3: Specify the threshold for 'Low' revenue (< 1000).
4. Step 4: Define the range for 'Medium' revenue (1000 to 5000).
5. Step 5: Assign 'High' revenue for all values above 5000.

• Revenue exactly at the threshold (1000 or 5000) may cause confusion in categorization.
• Negative revenue values should be handled appropriately, possibly categorized as 'Low'.
• Null revenue values need to be considered to avoid incorrect categorization.