Bineesh  Viswanath

Bineesh Viswanath

  • NA
  • 1k
  • 780.3k

Find Details of Employee in SQL

Jun 7 2013 12:06 AM


employeeId       lastName             firstName            middleName           jobId            managerId        hireDate                salary           comm     departmentId    
---------------- -------------------- -------------------- -------------------- ---------------- ---------------- ----------------------- ---------------- ----------- ----------------
7505                   DOYLE                  JEAN                         K                        671                7839              4/4/1985               2850          <NULL>          30              
7506                  DENNIS                LYNN                          S                        671                 7839              10/5/1985            2750           <NULL>         30              
7507                  BAKER                  LESLIE                       D                        671                 7839                9/6/1985            2200           <NULL>         40              
7499                   ALLEN                KEVIN                          J                        670                  7698               12/4/1984          1600              300             30              
7521                   WARK                CYNTHIA                      D                        670                   7698             4/2/1985             1250              500             30              
7369                   SMITH                  JOHN                         Q                        667                   7902              12/5/1984           800             <NULL>        20


26.List out the no.of employees for each month and year, in the ascending order based on the year, month.

27.List out the department id having atleast four employees.

28.How many employees in January month.

29.How many employees who are joined in January or September month.

30.How many employees who are joined in 1985.

31.How many employees joined each month in 1985.

32.How many employees who are joined in March 1985.

33.Which is the department id, having greater than or equal to 3 employees joined in April 1985


Please send me the query for the above questions. Take Your own time for this.






Answers (2)