00:00:00

Description

Editorial

Canonical User Display Name Formatter

EASY10 pts

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

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

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

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.

Accepted0/0·0% Acceptance

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

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

users =

[{"user_id":1,"name":"aLice"},{"user_id":2,"name":"bOB"}]

Loading problem...

101

00:00:00

Description

Editorial

Canonical User Display Name Formatter

EASY10 pts

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

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

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

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.

Accepted0/0·0% Acceptance

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

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

users =

[{"user_id":1,"name":"aLice"},{"user_id":2,"name":"bOB"}]

Canonical User Display Name Formatter

Hints

Canonical User Display Name Formatter

Hints