How should I practice Most Recent Active User Per Department?

Start by reading the full statement, solve the visible examples, then compare the pattern against related Lenskart online assessment problems in FastPrep.

Is Most Recent Active User Per Department associated with Lenskart?

FastPrep tags this as a Lenskart online assessment coding practice problem when the problem catalog has that company and stage context.

Problem · Database

Most Recent Active User Per Department

● Easy

LenskartFULLTIMEOA

Problem statement

The table activity_logs stores user-activity records in input order. For each department, return the user from the row with the largest last_seen timestamp.

If several rows in one department share its largest timestamp, keep the row with the smallest log_position.
Order departments by the smallest log_position at which each department appears.

Return department and user_id. The reported exercise formats these ordered pairs as a semicolon-delimited string; the tabular workspace represents the same pairs as ordered result rows.

Input table

activity_logs
Column	Meaning
`log_position`	One-based position of the record in the input
`department`	Department name
`user_id`	User identifier
`last_seen`	Activity timestamp

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_logs

One row per activity record, with explicit input order.

Column	Type	Nullable	Description
log_positionPK	Integer	No	—
department	Text	No	—
user_id	Text	No	—
last_seen	Integer	No	—

Expected result

Your query or function must return these columns.

Column	Type	Nullable	Description
department	Text	No	—
user_id	Text	No	—

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

Constraints

The activity_logs table has between 1 and 10^5 rows.
log_position is unique, non-null, and records the input order.
department and user_id are non-null strings of length from 1 through 50.
0 <= last_seen <= 10^9.