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;