What WHERE clause is equivalent to the WHERE clause on the SELECT statement below?SELECT * FROM CustomerWHERE lastname IN ('Smith', 'Jones') | Coldfusion MCQs

A. WHERE lastname = 'Smith' OR 'Jones'
B. WHERE lastname = 'Smith' AND lastname = 'Jones'
C. WHERE lastname BETWEEN 'Smith' AND 'Jones'
D. WHERE lastname = 'Smith' OR lastname = 'Jones'

Ans: D