Published on

Leetcode - 1667. Fix Names in a Table

Authors
  • avatar
    Name
    Indo Yoon
    Twitter
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