I have XML data in nvarchar column I need to get that xml data to new columns

XML data in nvarchar column name as catalog_names

<catalogs>
<Catalog Name="NEWYORK"
RequireApprove="True"/>
</catalogs>

I need Catalog name and RequireApprove in two new columns. please provide query for this in SQL