SUBSTRING
function to separate the first character of the 'name' field.UPPER
function to convert the first character to uppercase.SUBSTRING
function again to separate the rest of the 'name' field starting from the second character.LOWER
function to convert the rest of the 'name' to lowercase.CONCAT
function to combine the uppercase first character with the lowercase rest of the name.ORDER BY
clause to sort the results by 'user_id'.erDiagram Users { int user_id varchar name }