题解 | #纠错4#
纠错4
https://www.nowcoder.com/practice/bde1451b91084c8cab467387a0e0969c
select * 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') a ORDER BY a.cust_name;