Altimetrik Interview Question

Different join and their examples