Country with the Most Events
Notion● MediumFULLTIMEPHONE SCREENProblem statement
Given user locations and an event log, return the country associated with the largest number of events.
Count every event. If several countries tie, return the alphabetically smallest country. Return exactly the columns country and event_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.
users
| Column | Type | Nullable | Description |
|---|---|---|---|
| user_idPK | Integer | No | — |
| country | Text | No | — |
events
| Column | Type | Nullable | Description |
|---|---|---|---|
| event_idPK | Integer | No | — |
| user_id | Integer | No | — |
| event_type | Text | No | — |
| event_time | Timestamp | No | — |
Foreign key: user_id → users(user_id)
Expected result
Your query or function must return these columns.
| Column | Type | Nullable | Description |
|---|---|---|---|
| country | Text | No | — |
| event_count | Integer | No | — |
Row order: must match exactly. Numeric tolerance: 0.
Constraints
- Every event references one listed user.
- At least one event is present.
- Country names compare by their stored case-sensitive text.