Convert xml to table in sql

Hi,

I have an xml in following format,
I want to convert the below XML to the table in sql.the output has to be something like this.
Does anyone done this before??

---Output----


-----XML----