Query Problems

Hi

I have been trying these queries on scott.

select e.ename,e.deptno
from emp e,salgrade g,(select deptno,count(*) total
from emp
group by deptno)d
where e.sal between g.losal and g.hisal
and g.losal=(select min(losal)
from salgrade)
and d.total>2
and e.deptno=d.deptno

Does this qquery inclde where there is more than 2 employees

And the following query

select d.deptno,d.dname,d.loc
from emp e,dept d
where d.deptno=e.deptno
and e.job='CLERK'

In the output it does not give the details of clerks and there is repeated data which states:

20 reserach dallas
20 reserach dallas

Can anyone advise me on these queries?

Question: Does this qquery inclde where there is more than 2 employees

select e.ename,e.deptno
from emp e,salgrade g,(select deptno,count(*) total
from emp
group by deptno)d
where e.sal between g.losal and g.hisal
and g.losal=(select min(losal)
from salgrade)
and d.total>2
and e.deptno=d.deptno

Yes it does.