使用SQL Server从命名为相同的XML节点获取所有数据

I have an XML file where the nodes that I need the data from are all named the same. I understand how to access the first (or second record) so the following query only gives me the second author (the I have an XML file where the nodes that I need