A.
select count(*) from emp where deptno= (select deptno from emp where ename='SCOTT');
B.
select sum(*) from emp where deptno= (select deptno from emp where ename='SCOTT');
C.
select * from emp where empno= (select empno from emp where ename='SCOTT');
D.
select * from emp where deptno= (select deptno from emp where ename='SCOTT');