question_answer

Which of the following SQL commands is CORRECT, if you want to display name and section of those students whose section is either A or C?

A) SELECT name, section FROM students WHERE section BETWEEN ('A', 'C');

B) SELECT name, section FROM student WHERE section LIKE 'A' and 'C';

C) SELECT name, section FROM student WHERE section IN ('A', 'C');

D) SELECT name, section FROM students WHERE section BETWEEN 'A' AND 'C';