W3School TIY Editor

SELECT ProductName, Price, CASE WHEN Price < 20 THEN 'Low Cost' WHEN Price BETWEEN 20 AND 50 THEN 'Medium Cost' ELSE 'High Cost' END AS PriceCategory FROM Products;