1811. Fix Names in a Table
My accepted SQL solution to LeetCode problem 1811, Fix Names in a Table, running in 567ms.
- Difficulty: Easy
- SQL
- Runtime 567ms
- Memory 0.0B
- Updated
Read the problem on LeetCode View on GitHub
The problem statement is LeetCode’s and stays on their site. What follows is my accepted solution.
SQL
Accepted on LeetCode — runtime 567ms, memory 0.0B, accepted 2025-12-31.
SELECT user_id,
CONCAT(UPPER(LEFT(name, 1)), LOWER(SUBSTRING(name, 2))) AS name
FROM Users
ORDER BY user_id