Pergunta de entrevista da empresa Sandstone Technology

How many joins are there and explain the difference.