LEFT JOIN Losing Rows After a WHERE

Company: Tummee_9sep

Difficulty: medium

Problem Statement

Question 1

A LEFT JOIN unexpectedly drops rows with no match after a WHERE on the joined table. The cause is: