Mostly asked SQL join Question in interview !!!

Hello Friends, I am back with another topic of SQL joint operation. I failed to answer this question. Hence after good understanding of join concept, i created this tutorial for you. keep learning ,keep improving !!!