問題
解いた
CONCAT関数やSUBSTRING関数といった文字列関数を使うと解ける
SELECT user_id, CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS name FROM Users ORDER BY user_id;
CONCAT関数やSUBSTRING関数といった文字列関数を使うと解ける
SELECT user_id, CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS name FROM Users ORDER BY user_id;