Can we use two where clauses at a time?

Question

select ename, sal 
from emp 
where sal between 1500 and 3000 
where job = 'manager' and deptno = 30;

I am getting an error like "sql command not properly ended"

Answer 1

You could write:

select ename,sal from emp 
where job='manager' and deptno=30 and sal between 1500 and 3000;