Pergunta de entrevista da empresa Cleveland Clinic

How do you normalize tables? Whats the difference between JOIN and LEFT JOIN in SQL?