SQL problem - Fix Names in a Table
Problem
Query
SELECT
user_id,
CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(name, 2))) as name
FROM
Users
ORDER BY
user_id
Editorial Solution
SELECT user_id, CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS name
FROM Users
ORDER BY user_id;