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