How to display the names of employees in Sql Query?

Question

How to display the names of employees who are working as clerk , salesman or analyst and drawing a salary more than 3000 in Oracle?

Answer 1

select employeename from employee where department in('clerk','salesman','analyst') and salary >3000