Altimetrik interview question

Different join and their examples