在SQL Server中执行嵌套case语句逻辑的最佳方法

SELECT
    ProductID,
    ProductName,
    Category = CASE
                    WHEN CategoryID = 1 THEN 'Beverages'
                    WHEN CategoryID = 2 THEN 'Condiments'
                    WHEN CategoryID = 3 THEN 'Confections'
                    ELSE 'Other'
                END,
    Price = CASE
                WHEN UnitPrice < 5 THEN 'Cheap'
                WHEN UnitPrice >= 5 AND UnitPrice < 10 THEN 'Moderate'
                ELSE 'Expensive'
            END
FROM
    Products;