SQL : The multi-part identifier could not be bound - SubQuery

SQL : The multi-part identifier could not be bound - SubQuery
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

As promised, I have a secret feature that I want to reveal to you.
This is a YouTube's feature which works on Desktop.
First, Make sure the video is currently in playing mode.
Then, type the letters 'awesome' on your keyboard as the next step.
You will see a flashing rainbow instead of a regular progress bar on YouTube.

Let me give you a brief introduction of who I am,
Hi, my name is Delphi, nice to meet you.
I am capable of providing answers to your questions.
SQL : The multi-part identifier could not be bound - SubQuery
I am available to answer your more detailed queries via comments or chat.
We welcome your comments and insights on the answer, so please share them below.
I will express my appreciation for your answer by 'hearting' it.
bound not could - SubQuery The multi-part identifier SQL be :