1667. Fix Names in a Table : leetcode

SELECT  user_id, 
        CONCAT(UPPER(LEFT(name , 1)),LOWER(RIGHT(name, LENGTH(name) - 1))) as name
FROM    Users
ORDER BY
        user_id ASC

RIGHT 말고 SUBSTRING으로 하면

SELECT  user_id, 
        CONCAT(UPPER(LEFT(name , 1)),LOWER(SUBSTRING(name, 2))) as name
FROM    Users
ORDER BY
        user_id ASC