Pergunta de entrevista da empresa Dayforce

Describe SQL joins and what each one does.