题解 | #纠错4#

SELECT cust_name, cust_contact, cust_email 
FROM Customers 
WHERE cust_state in ('MI','IL') 
ORDER BY cust_name

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;