SQL Challenge
User accounts.
| Name | Type | Notes |
|---|---|---|
| user_id | INT | Primary key |
| username | VARCHAR | Username |
| user_id | username |
|---|---|
| 1 | alice123 |
| 2 | bob456 |
| 3 | charlie789 |
User login history.
| Name | Type | Notes |
|---|---|---|
| login_id | INT | Primary key |
| user_id | INT | Foreign key |
| login_date | DATE | Login date |
| login_id | user_id | login_date |
|---|---|---|
| 1 | 1 | 2024-01-01 |
| 2 | 1 | 2024-01-02 |
| 3 | 1 | 2024-01-03 |
| 4 | 1 | 2024-01-04 |
| 5 | 2 | 2024-01-01 |
| 6 | 2 | 2024-01-03 |
| 7 | 3 | 2024-01-01 |
| 8 | 3 | 2024-01-02 |
| 9 | 3 | 2024-01-03 |
Result Preview
Awaiting RunRun your query to see the dataset preview.
.svg){kind=icon}