[SQL] Query XML Containing Namespace

WITH XMLNAMESPACES ('http://www.blogger.com' as ns)
select XMLRESULT.value('(/ns:AAA//ns:BBB//DDD/node())[1]', 'nvarchar(max)')
from TABLE

Key: WITH XMLNAMESPACES.