Help needed with SQL

Hi there! I am new to SQL and thus have a question which must be a piece of cake for all you experts. If so, please help me with it. There are two tables:

Table 1: A.dept

      DEPTNO DNAME LOC DEPTHEAD

• --------------- ------------- ---------- 10 info processing new york 7698 20 office staff dallas 7566 30 sales chicago 7782

Table 2: B.emp

      EMPNO ENAME      JOB                MGR HIREDATE      DEPTNO
---------- ---------- ----------- ---------- --------- ----------
      7369 smith      clerk             7902 17-DEC-80         20
      7499 allen      salesperson       7698 20-FEB-81         30
      7521 ward       salesperson       7698 22-FEB-81         30
      7566 jones      manager           7839 02-APR-81         20
      7654 martin     salesperson       7698 28-SEP-81         30
      7698 blake      manager           7839 01-MAY-81         10
      7782 clark      manager           7839 09-JUN-81         30
      7788 scott      analyst           7566 09-DEC-82         20
      7839 king       president              17-NOV-81         10
      7844 turner     salesperson       7698 08-SEP-81         30
      7876 adams      clerk             7788 12-JAN-83         20
      7900 james      clerk             7698 03-DEC-81         30
      7902 ford       analyst           7566 03-DEC-81         20
      7934 miller     clerk             7782 23-JAN-82         10
      7286 garcia     salesperson       7698 25-SEP-89         30
      7287 schmidt    salesperson       7698 25-JUL-87         30
      7288 wong       salesperson       7698 25-SEP-91         30


The question is : Which departments have more emplpoyees than the 
                  department "office staff" ?

Send responses to smasudmz_at_caen.engin.umich.edu Received on Sat Jun 20 1992 - 06:14:22 CEST