MySQL : writing a sql query in MySQL with subquery on the same table

MySQL : writing a sql query in MySQL with subquery on the same table
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

I promised to reveal a secret feature to you, and now it's time to share it.
This is a YouTube's feature which works on Desktop.
First, Make sure the video is currently in playing mode.
After that, type the word 'awesome' on your keyboard.
It will change your youtube progress bar into a flashing rainbow.

A quick introduction about me,
Hey there, I am Delphi, pleased to make your acquaintance.
Let me aid you in resolving any queries you may have.
MySQL : writing a sql query in MySQL with subquery on the same table
Please don't hesitate to let me know if you have more specific queries by commenting or chatting with me.
Don't hesitate to provide your answer or insights by leaving a comment below.
Providing an answer will be acknowledged and appreciated with a 'heart' from me.
writing MySQL table the sql with a on same in subquery query : MySQL