题解 | #纠错4#
纠错4
https://www.nowcoder.com/practice/bde1451b91084c8cab467387a0e0969c
select
t.*
from
(SELECT cust_name, cust_contact, cust_email
FROM Customers
WHERE cust_state = 'MI'
UNION
SELECT cust_name, cust_contact, cust_email
FROM Customers
WHERE cust_state = 'IL') t
order by
t.cust_name
基恩士成长空间 437人发布