SQL : SQL: Alias Column Name for Use in CASE Statement

SQL : SQL: Alias Column Name for Use in CASE Statement
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

As promised, I have a hidden feature that I want to share with you.
This is a YouTube's feature which works on Desktop.
First, Ensure that the video is playing before proceeding.
Next, enter the letters 'awesome' on your keyboard.
You will see a flashing rainbow instead of a regular progress bar on YouTube.

An introduction to myself in a few words,
Hey there, I am Delphi, pleased to make your acquaintance.
I help you answer your questions.
SQL : SQL: Alias Column Name for Use in CASE Statement
If you have more specific query you can comment or chat with me and let me know your queries.
Please feel free to share your answer or insights on the answer by leaving a comment below.
Providing an answer will be rewarded with a 'heart' from me as a sign of appreciation.
Statement SQL in : CASE for SQL: Use Alias Column Name