Katkat
Back

Count Users Active After Signup

MixpanelData Scientist · Technical Screen
MediumData ScientistTechnical ScreenData Manipulation (SQL/Python)

Last updated

Count distinct users with at least one event on or after signup using a PostgreSQL query.

Count Users with an Event On or After Signup

You have these tables:

TableColumnMeaning
usersuser_idUser identifier.
userssignup_dateThe user's signup date or timestamp.
usersplan_typeThe user's plan type.
eventsuser_idUser associated with an event.
eventsevent_tsEvent timestamp.

Write one read-only PostgreSQL query to count distinct users who have at least one event whose event_ts is greater than or equal to their signup_date. Match events to user records by user_id.

A user with multiple qualifying events is counted once. Users with no qualifying events are excluded from the count.

Return exactly one row with one column named users_with_event. If nobody qualifies, the count is zero. Output row order is unrestricted.