Pregunta de entrevista de Inductive Automation

Difference between the SQL joins