Fix Names in Table
ASKED IN INTERVIEWAmazon
Problem Statement
Transform the name column so that only the first character is capitalized and the rest are lowercase.
Rules:
- Columns: user_id, name.
- Format: "Name".
- Sort by: user_id ASC.
Tests your understanding of
String Manipulation, UPPER, LOWER and SUBSTRING
Input Tables
users
| user_id(INTEGER) | name(VARCHAR) |
|---|---|
| 1 | aLICE |
| 2 | bob |
| 3 | CHARLIE |
regions
| region_id(INTEGER) | region_name(VARCHAR) |
|---|---|
| 1 | North America |
preferences
| user_id(INTEGER) | email_opt_in(BOOLEAN) |
|---|---|
| 1 | true |
Expected Output
| user_id(INTEGER) | name(VARCHAR) |
|---|---|
| 1 | Alice |
| 2 | Bob |
| 3 | Charlie |
Tags
EasyASKED IN INTERVIEWString ManipulationUPPERLOWERSUBSTRING
5-10 min
92%