Skip to main content

COUNT(*), COUNT(column), or COUNT(DISTINCT)?

Pick the appropriate COUNT form for rows, non-null values, or distinct entities.

sql-basics5 min read

The table is events. One user can create many events. Some events have NULL user_id because they are anonymous. The metric is active known users this week.

Read the full lesson

Sign up free: one personalized lesson every day, matched to your role and goals.

← Back to library

Contact us