Receta_TSQL-2.5.sql

SELECT ProductID AS IDProducto, Name AS Nombre, ProductNumber AS NúmeroProducto, "Grupo" =
    CASE
        WHEN ReorderPoint >= 100 AND ReorderPoint <= 300 THEN 'Grupo A'
        WHEN ReorderPoint >= 301 AND ReorderPoint <= 500 THEN 'Grupo B'
        WHEN ReorderPoint >= 501 AND ReorderPoint <= 700 THEN 'Grupo C'
        ELSE 'Grupo D'
    END
FROM Production.Product;