XML Attribute value access

Transact-SQL
1

I am trying to generate an output using Productname from below xml which will look like:

B/C/

B/D/E

Please find the demo xml and related query which I am already using at below location:

Details of xml query