Users First Login Date
ASKED IN INTERVIEWMeta
Problem Statement
Find the earliest login date for every user in the system.
Rules:
- Columns: user_id, first_login_date.
- Sort by user_id ASC.
Tests your understanding of
Aggregation, MIN and Filtering
Input Tables
login_logs
| log_id(INTEGER) | user_id(INTEGER) | login_date(DATE) |
|---|---|---|
| 1 | 101 | 2026-01-01 |
| 2 | 101 | 2026-01-05 |
| 3 | 102 | 2026-02-10 |
| 4 | 102 | 2026-02-08 |
users
| user_id(INTEGER) | username(VARCHAR) |
|---|---|
| 101 | meta_user_1 |
account_types
| id(INTEGER) | type_name(VARCHAR) |
|---|---|
| 1 | Premium |
Expected Output
| user_id(INTEGER) | first_login_date(DATE) |
|---|---|
| 101 | 2026-01-01 |
| 102 | 2026-02-08 |
Tags
EasyASKED IN INTERVIEWAggregationMINFiltering
5-10 min
89%