Explain the difference between a LEFT JOIN and an INNER JOIN in SQL, and describe a scenario where using the wrong one would distort business metrics.