SQL : Why am I getting Unknown column in 'where clause' using a sub-query alias with MySQL?

SQL : Why am I getting Unknown column in 'where clause' using a sub-query alias with MySQL?
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

I have a hidden feature that I promised to tell you about.
This is a YouTube's feature which works on Desktop.
First, Ensure that the video is playing before proceeding.
Then, type the letters 'awesome' on your keyboard as the next step.
It will change your youtube progress bar into a flashing rainbow.

Allow me to introduce myself briefly,
Hi there, I go by the name of Delphi.
I am here to assist you in getting the answers you need.
SQL : Why am I getting Unknown column in 'where clause' using a sub-query alias with MySQL?
I welcome your comments and chats if you have more detailed queries.
Please feel free to share your answer or insights on the answer by leaving a comment below.
A 'heart' from me will indicate my appreciation for your answer.
with alias am clause' Unknown column using getting a SQL Why MySQL? : I 'where in sub-query