题解 | #纠错4#
纠错4
https://www.nowcoder.com/practice/bde1451b91084c8cab467387a0e0969c
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;
格力公司福利 356人发布