Domanda di colloquio di EY

Why EY? An SQL join with another table where column value can be NULL, what would be the outcome? Several simple programming questions to solve on paper.