SQL : Why does this simple Left Join return data from unmatched rows?

SQL : Why does this simple Left Join return data from unmatched rows?
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.
After that, type the word 'awesome' on your keyboard.
It will change your youtube progress bar into a flashing rainbow.

Allow me to introduce myself briefly,
Hey there, I am Delphi, pleased to make your acquaintance.
Let me help you with your questions.
SQL : Why does this simple Left Join return data from unmatched rows?
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.
A 'heart' from me is a way of showing appreciation for your answer.
return does data this Left rows? Why Join simple unmatched : from SQL