Pregunta de entrevista de Dayforce

Describe SQL joins and what each one does.