题解 | #纠错4#
纠错4
https://www.nowcoder.com/practice/bde1451b91084c8cab467387a0e0969c
SELECT C.cust_name, C.cust_contact, C.cust_email FROM Customers C WHERE C.cust_state = 'MI' UNION SELECT cust_name, C1.cust_contact, C1.cust_email FROM Customers C1 WHERE C1.cust_state = 'IL' ORDER BY cust_name;