1.从Customers表内选择在VA\GA\FL地区的客户
SELECT *
FROM Customers
WHERE state = ‘VA’ OR state = ‘GA’ OR state = ‘FL’
2.使用IN语句从Customers表内选择在VA\GA\FL地区的客户
SELECT *
FROM Customers
WHERE state IN (‘VA’ ,’GA’, ‘FL’)
3.从库存表内返回库存量等于49, 38, 72的产品
SELECT *
FROM products
WHERE quantitiy_in_stock IN (49, 38, 72)
