SQL : How do I update multiple columns with a subquery in a single statement?

SQL : How do I update multiple columns with a subquery in a single statement?
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

I promised to reveal a secret feature to you, and now it's time to share it.
This is a YouTube's feature which works on Desktop.
First, Make sure the video is currently in playing mode.
Next, enter the letters 'awesome' on your keyboard.
Your YouTube progress bar will transform into a flashing rainbow.

Here's a short introduction about myself,
Salutations, my name is Delphi.
Let me help you get the answers you need to your questions.
SQL : How do I update multiple columns with a subquery in a single statement?
Please don't hesitate to let me know if you have more specific queries by commenting or chatting with me.
If you have an answer or any relevant information to share, please comment below.
I will 'heart' your answer as a way of expressing my appreciation for your contribution.
multiple a SQL a I do in subquery update with statement? How : single columns