In operator is used to choose among a value set
like IN (1,2,3,4) etc
BETWEEN is used for range.
e.g. List all the Employee Fname, Lname who is having salary between 30000 and 45000.
SELECT Fname, Lname
FROM Employee
WHERE Salary
BETWEEN 30000 AND 45000;
Answer : D as per syntax.