Execute the following
Execute the following Microsoft SQL Server Transact-SQL (T-SQL) script in Management Studio (SSMS) Query Editor, SQLCMD or other client software
to demonstrate the use of XMLNAMESPACES:

USE AdventureWorks;

WITH XMLNAMESPACES( 'urn:example.com/customer'
as c ),
cteDirRpt(ManagerID, StaffCount) AS (
SELECT ManagerID, count(*)
FROM HumanResources.Employee
WHERE ManagerID is not null
GROUP BY ManagerID)

SELECT [c:ManagerID] = ManagerID, StaffCount
FROM cteDirRpt
ORDER BY ManagerID
FOR XML PATH;