How should I practice Users Active in Both January and February?

Start by reading the full statement, solve the visible examples, then compare the pattern against related Mygate phone screen problems in FastPrep.

Is Users Active in Both January and February associated with Mygate?

FastPrep tags this as a Mygate phone screen coding practice problem when the problem catalog has that company and stage context.

Users Active in Both January and February

Mygate● EasyFULLTIMEPHONE SCREEN

Problem statement

The activity table records user activity events. Each row counts as one activity, and activity_date is a calendar date with no time or timezone conversion.

Find every user who has at least one activity in January 2025 and at least one activity in February 2025. Return one user_id row per qualifying user, sorted by user_id in ascending order.

Repeated events on the same date count as activity, but must not create duplicate result rows. Activity outside those two months, including the same months in another year, does not count.

Table schema

MySQLPostgreSQLPandas

Use the same input data with any supported language. Open the Schema tab in the editor to see the generated SQL setup or Pandas DataFrames.

activity

One row per user activity event.

Column	Type	Nullable	Description
event_idPK	Integer	No	—
user_id	Integer	No	—
activity_date	Date	No	—

Expected result

Your query or function must return these columns.

Column	Type	Nullable	Description
user_id	Integer	No	—

Row order: must match exactly. Numeric tolerance: 0.

Constraints

The table contains between 0 and 10^4 rows.
event_id is unique and between 1 and 10^9.
user_id is an integer between 1 and 10^9.
activity_date is a valid date between 2020-01-01 and 2030-12-31.