题解 | #用户名规范化#

with cte as (
select device_id,substring_index(blog_url,'/',-1) as name
from user_submit   )

select device_id,concat(upper(left(name,1)),lower(right(name,length(name)-1))) as user_name
from cte
order by device_id desc