Dear Experts
i am new to this forum and my first post, i really stuck with one XML file and need expert advice.
I have to generate a XML file file based on table data, i designed the structure as per XML tags but have to idea how to get the XML file as sample attached.
XML generated from SQL is very simple, , if anyone can help me in how to move right direction to get the same result.
generated XML schema in VS 2015 based on xml , i got 4 xsd files and they are not validating in sql when i am trying to create xml schema in sql server.
thanks for your kind help.

not able to attach xml file, dont know why system is not accepting it.