case expression

case expression

SELECT productnumber, 
       name, 
       'Price Range' = CASE  
                           WHEN listprice = 0 THEN 'Mfg item - not for resale'  
                           WHEN listprice < 50 THEN 'Under $50'  
                           WHEN listprice >= 50  
                                AND listprice < 250 THEN 'Under $250'  
                           WHEN listprice >= 250  
                                AND listprice < 1000 THEN 'Under $1000'  
                           ELSE 'Over $1000'  
                       END  
FROM   production.product  
ORDER  BY productnumber;