题解 | #用户名规范化#
用户名规范化
https://www.nowcoder.com/practice/fcf0413ca8164324a91e7e2f4421f369
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
查看4道真题和解析
