题解 | #纠错4#

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