DISTINCT on multiple columns

Question

Accepted Answer

DISTINCT removes rows where the entire selected combination is identical. Alice + shipped appears in rows 1 and 3 - that pair collapses to one row. Alice + pending and Bob + pending are each unique, so they remain. The result has 3 rows. A common mistake is assuming DISTINCT applies per-column independently - it applies to the full combination of selected columns.