使用T-SQL语法生成复杂的XML

I am trying to build a query that would return more or less complex XML structure. This is expected output I would like to have:I am trying to build a query that would return