In my application database, customer order information is stored as xml in a nvarchar field in sql server. I want to extract all orders which are valued more than 1000. Please find the below sample xml and help me with the query.
Sample xml <customer> <orders> <order> <orderdate>2022-01-01</orderdate> <ordervalue>5000</ordervalue> </order> <order> <orderdate>2022-01-21</orderdate> <ordervalue>800</ordervalue> </order> <order> <orderdate>2022-02-17</orderdate> <ordervalue>1500</ordervalue> </order> <order> <orderdate>2022-03-30</orderdate> <ordervalue>9000</ordervalue> </order> </orders> </customer>