Receta_TSQL-2.4.sql

SELECT DepartmentID AS IDDepartamento, Name AS Nombre, GroupName AS NombreGrupo,
    CASE GroupName
        WHEN 'Research and Development' THEN 'Módulo A'
        WHEN 'Sales and Marketing' THEN 'Módulo B'
        WHEN 'Manufacturing' THEN 'Módulo C'
    ELSE 'Módulo D'
    END AS Modulo
FROM HumanResources.Department;