Write SQL and Python, run instantly in your browser, and track your progress.
You are a Backend Engineer at X (Twitter). The Search team needs usernames normalized to lowercase for case-insensitive searching. Convert all usernames to lowercase for indexing purposes.
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
| account_status | object |
You are a Backend Engineer at X (Twitter). The Search team needs usernames normalized to lowercase for case-insensitive searching. Convert all usernames to lowercase for indexing purposes.
| Column Name | Type |
|---|---|
| user_id | int64 |
| username | object |
| full_name | object |
| account_status | object |
| user_id | username | full_name | account_status |
|---|---|---|---|
| 1 | andrea4 | Andrea Davis | active |
| 2 | its_emily | Emily Anderson | active |
| 3 | karen_wilson | Karen Wilson |
| user_id | username | full_name | account_status |
|---|---|---|---|
| 1 | andrea4 | Andrea Davis | active |
| 2 | its_emily | Emily Anderson | active |
| 3 | karen_wilson | Karen Wilson |
| user_id | username | full_name | account_status | username_lower |
|---|---|---|---|---|
| 1 | andrea4 | Andrea Davis | active | andrea4 |
| 2 | its_emily | Emily Anderson | active | its_emily |
| 3 | karen_wilson | Karen Wilson | active | karen_wilson |
| user_id | username | full_name | account_status | username_lower |
|---|---|---|---|---|
| 1 | andrea4 | Andrea Davis | active | andrea4 |
| 2 | its_emily | Emily Anderson | active | its_emily |
| 3 | karen_wilson | Karen Wilson | active | karen_wilson |
Showing first 5 of 60 rows.
Showing first 5 of 60 rows.
1. Data Selection:
2. String Transformation:
3. Output:
1. Data Selection:
2. String Transformation:
3. Output:
| active |
| active |
| 4 | liam80 | Liam O'Brien | active |
| 4 | liam80 | Liam O'Brien | active |
| 5 | liam21 | Liam Patel | active |
| 5 | liam21 | Liam Patel | active |
| 4 | liam80 | Liam O'Brien | active | liam80 |
| 4 | liam80 | Liam O'Brien | active | liam80 |
| 5 | liam21 | Liam Patel | active | liam21 |
| 5 | liam21 | Liam Patel | active | liam21 |