OCP CBT Question 650

Please solve the following question.

You need to find all employees whose `department_id` is either 50, 60, or 80. Which operator should you use for the most concise and readable SQL statement?

sqlSELECT employee_id, first_name, department_id FROM employees;

EMPLOYEES Table Sample Data

EMPLOYEE_ID FIRST_NAME DEPARTMENT_ID
100 Steven 90
101 Neena 90
102 Lex 60
103 Alexander 60
104 Bruce 50
105 David 80
106 Valli 50