SQL : Extracting child node value from XML using T-SQL

SQL : Extracting child node value from XML using T-SQL
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

As I promised, I have a secret feature to share with you.
This is a YouTube's feature which works on Desktop.
First, Ensure that the video is playing before proceeding.
After that, type the word 'awesome' on your keyboard.
The progress bar on YouTube will be altered to a flashing rainbow.

Allow me to introduce myself briefly,
Hey, I'm known as Delphi.
I am here to assist you in getting the answers you need.
SQL : Extracting child node value from XML using T-SQL
I am always open to chatting or receiving comments from you if you have more specific queries.
If you have an answer, or any insights to the answer, please comment below.
I will 'heart' your answer as a sign of appreciation.
: T-SQL node Extracting SQL from child XML value using