题解 | #纠错4#

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;

组合查询只能用一条order by 子句 且必须用在最后一条select子句后