How many rows does deduplication keep?

Question

Accepted Answer

DISTINCT removes duplicate values from the result. Alice appears twice in the table but only once in the output. The result contains one row per unique customer value: Alice, Bob, Carol.