Skip to content

1667. Fix Names in a Table 👍

1
2
3
4
5
6
7
8
SELECT
  user_id,
  CONCAT(
    UPPER(SUBSTRING(name, 1, 1)),
    LOWER(SUBSTRING(name, 2))
  ) AS name
FROM Users
ORDER BY 1;