A retail chain wants to target customers from specific state…
A retail chain wants to target customers from specific states. Their customers table includes a state column. If they only want records where the state is either ‘WI’, ‘IL’, or ‘MN’, which SQL should they use? SELECT * FROM customers WHERE state = ‘WI’ AND ‘IL’ AND ‘MN’ SELECT * FROM customers WHERE state IN (‘WI’, ‘IL’, ‘MN’) SELECT * FROM customers WHERE state BETWEEN ‘WI’ AND ‘MN’ SELECT * FROM customers WHERE state LIKE ‘WIMNIL’ Answer: SELECT * FROM customers WHERE state IN (‘WI’, ‘IL’, ‘MN’) Explanation: The IN clause allows filtering by a specific set of values. Using AND would fail because a single record cannot equal multiple states at once. BETWEEN and LIKE are not appropriate for discrete, exact values.