When might we see empty cells in the result table of a LEFT JOIN, like in the image below?

When a row in the left table has no match in the right tableWhen a row in the left table has multiple matches in the right table

When a row in the left table has no match in the right table.