WHERE

-- Find all orders from specific countries
SELECT *
FROM orders
WHERE ship_country IN ('France', 'Austria', 'Spain');