题解 | #顾客登录名#
顾客登录名
https://www.nowcoder.com/practice/7cbf5e3082954c21a80fc750ce97350f
SELECT
cust_id,
cust_name,
UPPER(CONCAT(LEFT (cust_name, 2), LEFT (cust_city, 3))) AS user_login
FROM
Customers
顾客登录名
https://www.nowcoder.com/practice/7cbf5e3082954c21a80fc750ce97350f
SELECT
cust_id,
cust_name,
UPPER(CONCAT(LEFT (cust_name, 2), LEFT (cust_city, 3))) AS user_login
FROM
Customers
相关推荐