题解 | #纠错4#
纠错4
http://www.nowcoder.com/practice/bde1451b91084c8cab467387a0e0969c
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' ORDER BY cust_name;
，第一家确实难找，如果第一家没有太大的坑直接去就行了