Which row combinations collapse?

Question

Accepted Answer

DISTINCT applies to the entire selected row - a row is a duplicate only if all selected column values match. Rows 1 and 2 are both (Alice, shipped) - that pair collapses to one row. The three unique (customer, status) combinations are: (Alice, shipped), (Alice, pending), (Bob, shipped). Result: 3 rows.