Canonical User Display Name Formatter

Easy

A customer identity platform receives user names from many upstream systems with inconsistent casing. Table: users user_id: unique identifier for each user name: raw display name containing only English alphabet letters Task: Produce a normalized result where each name follows this exact casing format: first character uppercase every remaining character lowercase Output requirements: Return columns in this exact order: user_id name Sort output by user_id in ascending order. Supported submission environments: SQL (SQLite 3.27.2) Pandas (Python)

Example 1

Input

users:
| user_id | name  |
|---------|-------|
| 1       | aLice |
| 2       | bOB   |

Output

[
  {"user_id":1,"name":"Alice"},
  {"user_id":2,"name":"Bob"}
]

Explanation

Each row is normalized independently by uppercasing the first letter and lowercasing the rest.

Example 2

Input

users:
| user_id | name      |
|---------|-----------|
| 10      | cHARLIE   |
| 4       | EVE       |
| 7       | m         |
| 6       | dAvId     |

Output

[
  {"user_id":4,"name":"Eve"},
  {"user_id":6,"name":"David"},
  {"user_id":7,"name":"M"},
  {"user_id":10,"name":"Charlie"}
]

Explanation

Single-character names remain one character, and output sorting is by user_id rather than input order.

Example 3

Input

users:
| user_id | name      |
|---------|-----------|
| 21      | ALPHA     |
| 22      | alpha     |
| 23      | AlPhA     |

Output

[
  {"user_id":21,"name":"Alpha"},
  {"user_id":22,"name":"Alpha"},
  {"user_id":23,"name":"Alpha"}
]

Explanation

Different source casing variants converge to the same canonical display format.

Constraints

1 <= number of rows in users <= 50000
1 <= user_id <= 1000000000
user_id is unique
1 <= length(name) <= 100
name contains only uppercase and lowercase English letters
Return exactly two columns: user_id, name
Result must be sorted by user_id ascending
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with columns: user_id, name