SQL/LeetCode

[LeetCode] 1667. Fix Names in a Table

yeyeyep 2025. 2. 21. 15:45

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT user_id
     , CONCAT(UPPER(SUBSTR(name, 1, 1)), LOWER(SUBSTR(name, 2))) AS name
FROM Users
ORDER BY user_id ASC