Pergunta de entrevista da empresa Medicomp

Describe to me the difference between the different joins in SQL.