1667. Fix Names in a Table

https://leetcode.com/problems/fix-names-in-a-table/

Fix Names in a Table - LeetCode

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

Best

SELECT USER_ID, (CONCAT(UPPER(SUBSTR(NAME, 1, 1)), LOWER(SUBSTR(NAME, 2)))) AS NAME 
FROM USERS ORDER BY USER_ID

References

https://jhnyang.tistory.com/417

[오라클, MySQL] 대소문자와 관련된 UPPER, LOWER, INITCAP함수 사용법. 대문자로 변경, 소문자로 변경