SQL : Join the same table twice with conditions

SQL : Join the same table twice with conditions
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 this video is playing.
Then, type the letters 'awesome' on your keyboard as the next step.
You will see a flashing rainbow instead of a regular progress bar on YouTube.

A short overview of who I am,
Hey, I'm known as Delphi.
I am at your disposal to help you with any questions you have.
SQL : Join the same table twice with conditions
I am available to answer your more detailed queries via comments or chat.
We welcome your thoughts and feedback, so please comment below with your answer or insights to the answer.
Providing an answer will be acknowledged and appreciated with a 'heart' from me.
the Join table SQL : same conditions with twice

Скачать видео