Two independent COUNT(DISTINCT) in one query

Question

Accepted Answer

COUNT(DISTINCT product) counts unique product values: Widget and Gadget = 2. COUNT(DISTINCT region) counts unique region values: East and West = 2. Both aggregates run independently across all rows. The result is a single row with two counts.