COUNT(DISTINCT column)

Question

Accepted Answer

COUNT(DISTINCT column) counts unique non-NULL values only. Alice appears twice but is counted once. The distinct customers are Alice, Bob, and Carol - 3 unique values. This is useful for answering 'how many unique customers placed an order?'