题解 | #顾客登录名#
顾客登录名
https://www.nowcoder.com/practice/7cbf5e3082954c21a80fc750ce97350f
select
cust_id,
cust_name,
upper(
concat (
substring(cust_name, 1, 2),
substring(cust_city, 1, 3)
)
) as user_login
from
Customers
