Pregunta de entrevista de Walt Disney Company

What is inner vs. left join how would you dedup table