Task: Query XML Values and Attributes from a Table in SQL Server

Task: Query XML Values and Attributes from a Table in SQL Server: a task in Terminal-Lego-15k (Harbor dataset). Write a SQL script that correctly extracts XML attribute values and element text from an XML column in a SQL Server table. The XML contains multiple <Metric elements, and the query must…