Pergunta de entrevista da empresa CHS Inc

Explain different JOINS in SQL and give example for each.