Fix Names In A Table Problem


Description

LeetCode Problem 1667.

Table: Users

1
2
3
4
5
6
7
8
+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| user_id        | int     |
| name           | varchar |
+----------------+---------+
user_id is the primary key for this table.
This table contains the ID and the name of the user. The name consists of only lowercase and uppercase characters.

Write an SQL query to fix the names so that only the first character is uppercase and the rest are lowercase.

Return the result table ordered by user_id.

The query result format is in the following example:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Users table:
+---------+-------+
| user_id | name  |
+---------+-------+
| 1       | aLice |
| 2       | bOB   |
+---------+-------+

Result table:
+---------+-------+
| user_id | name  |
+---------+-------+
| 1       | Alice |
| 2       | Bob   |
+---------+-------+


MySQL Solution

1
2
3
4
select user_id, 
    concat(upper(left(name,1)),lower(substring(name,2))) as name
from Users 
order by user_id




Related Posts

Biggest Window Between Visits Problem

LeetCode 1709. Write an SQL query that will, for each...

Number Of Calls Between Two Persons Problem

LeetCode 1699. Write an SQL query to report the number...

Daily Leads And Partners Problem

LeetCode 1693. Write an SQL query that will, for each...

Product's Worth Over Invoices Problem

LeetCode 1677. Write an SQL query that will, for all...

Fix Names In A Table Problem

LeetCode 1667. Write an SQL query to fix the names...

Invalid Tweets Problem

LeetCode 1683. Write an SQL query to find the IDs...