Pergunta de entrevista da empresa Avant

Explain the differences between the JOINS?