Domanda di colloquio di Cleveland Clinic

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