DISTINCT COUNT
Intermediate
The sales report headline says "orders from N customers". There are six orders, but several customers ordered more than once, so counting rows overstates N.
Write a query returning a single value, the number of distinct user_ids in orders, named customer_count.
Constraints
- Return a single row with the column
customer_count - Each customer counts once however many orders they placed
Hints
Hint 1
COUNT(DISTINCT column) counts unique values.
Hint 2
COUNT(*) would return 6, the number of orders.
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.