# 1667. 修复表中的名字
# https://leetcode-cn.com/problems/fix-names-in-a-table/

# SQL架构
Create table If Not Exists Users (user_id int, name varchar(40));
Truncate table Users;
insert into Users (user_id, name) values ('1', 'aLice');
insert into Users (user_id, name) values ('2', 'bOB');

# Write your MySQL query statement below
select
    user_id,
    concat(
        upper(substring(name, 1, 1)),
        lower(substring(name, 2))
    ) as name
from
    Users
order by
    user_id;

# clean-up
drop table Users;