Khusus VIP student (database)

1.select ename from emp where job='manager' and deptno in(10,20,30);
2.select ename from emp where job='manager';
3.select ename from emp where ename not in('smith','allen','scott','king','adams','james',ford',turner','miller','martin');
4.select ename from emp where mgr=7839;
5.select ename from emp where sal between 2000 and 3000 and name not in('scott','ford')
6.select e.ename from emp e,dept d where e.job='manager' and e.deptno=d.deptno;
7.select ename from emp where ename in('blake','clark','jones');
8.select ename from emp where hiredate between '1981-04-02' and '1981-06-09';
9.select ename from emp where mgr=(select mgr from emp where hiredate=19810501);
10.select ename from emp where empno in(7698,7566,7782);