HF RL Explorer

Task: Extract Values from XML Field in SQL Database

Task: Extract Values from XML Field in SQL Database: a task in Terminal-Lego-15k (Harbor dataset). You have a SQLite database containing a table with an XML field. Each row stores person information in XML format. Your task is to write a SQL query or script that extracts the FirstName and LastName…

The task

You have a SQLite database containing a table with an XML field. Each row stores person information in XML format. Your task is to write a SQL query or script that extracts the `FirstName` and `LastName` values from the XML data and returns them as separate columns.

Part of PrimeIntellect/Terminal-Lego-15k.