The following two SQL statements will produce different results.
SELECT last_name, first_name
FROM customer
WHERE state = 'MA' OR state = 'NY' OR state = 'NJ' OR state = 'NH' OR state = 'CT';

SELECT last_name, first_name
FROM customer
WHERE state in ('MA','NY','NJ','NH','CT');

Question

The following two SQL statements will produce different results.
SELECT last_name, first_name
FROM customer
WHERE state = 'MA' OR state = 'NY' OR state = 'NJ' OR state = 'NH' OR state = 'CT';

SELECT last_name, first_name
FROM customer
WHERE state in ('MA','NY','NJ','NH','CT');

Quizplus · Accepted Answer

Both SQL statements will produce the same results as they filter the 'customer' table for the same set of states using different syntax.

The Following Two SQL Statements Will Produce Different Results