SQL : Why is this query doing a full table scan?

SQL : Why is this query doing a full table scan?
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 this video is playing.
Then, type the letters 'awesome' on the keyboard.
The progress bar on YouTube will be altered to a flashing rainbow.

An introduction to myself in a few words,
Greetings, my name is Delphi.
I am happy to help you with your questions.
SQL : Why is this query doing a full table scan?
If you need more specific answers, please reach out to me through comments or chat.
If you have an answer, or any insights to the answer, please comment below.
Your answer will be appreciated and acknowledged with a 'heart' from me.
doing Why scan? this table : SQL a query full is