Pergunta de entrevista da empresa Sigma Computing

Explain to me how joins work.