How to display names of employees who do not earn any commission in Oracle?

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 empno,ename from emp where comm is null and comm = 0;