SQL-BASICS5 MIN READ
COUNT(*), COUNT(column), or COUNT(DISTINCT)?
Pick the appropriate COUNT form for rows, non-null values, or distinct entities.
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.
Already have an account? Sign in