#Fixing names column so only first letter is uppercase.
Table: Users
+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| user_id        | int     |
| name           | varchar |
+----------------+---------+
  
select user_id,
CONCAT (UPPER(LEFT(name,1)),
LOWER(right(name,LENGTH(name)-1)))
as name from Users
ORDER BY user_id;