← Quiz: SQL for Data Analysis: all 9 questions
Quiz: SQL for Data Analysis · Question 7 of 9
Why should a funnel use COUNT(DISTINCT userid)?
Why should a funnel use COUNT(DISTINCT user_id)?
- A.DISTINCT makes the query faster
- B.A user may repeat a step, but should be counted once per step
- C.COUNT without DISTINCT ignores NULLs
- D.It sorts the steps in order
Answer & explanation
Correct answer: A user may repeat a step, but should be counted once per step
Funnels measure users who reached a step, not how many events happened.
Can you get the rest right without peeking?
Take the timed Quiz: SQL for Data Analysis quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →