# Write your MySQL query statement below
SELECT user_id, CONCAT(UPPER(LEFT(name, 1)), LOWER(SUBSTRING(name, 2))) AS name
FROM Users
ORDER by user_id
其实就是需要了解几个函数
1.concat: 拼接结果
2.upper:把字符串替换成大写字符
3.lower:把字符串替换成小写字符
4:substring: 分割字符串
# Write your MySQL query statement below
SELECT user_id, CONCAT(UPPER(LEFT(name, 1)), LOWER(SUBSTRING(name, 2))) AS name
FROM Users
ORDER by user_id
其实就是需要了解几个函数
1.concat: 拼接结果
2.upper:把字符串替换成大写字符
3.lower:把字符串替换成小写字符
4:substring: 分割字符串