- Published on
Leetcode - 1667. Fix Names in a Table
- Authors
- Name
- Indo Yoon
Table of Contents
문제
[Loading...
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
LeetCode
](https://leetcode.com/problems/fix-names-in-a-table/)
정답
SELECT user_id,
CONCAT(UPPER(LEFT(name,1)), LOWER(MID(name, 2))) as name
FROM Users
ORDER BY user_id