From the following table, write a SQL query to count the number of employees in each department. Return department code and number of employees.

Sample table: emp_details

EMP_IDNO EMP_FNAME EMP_LNAME EMP_DEPT
--------- --------------- --------------- ----------
127323 Michale Robbin 57
526689 Carlos Snares 63
843795 Enric Dosio 57
328717 Jhon Snares 63
444527 Joseph Dosni 47
659831 Zanifer Emily 47
847674 Kuleswar Sitaraman 57
748681 Henrey Gabriel 47
555935 Alex Manuel 57
539569 George Mardy 27
733843 Mario Saule 63
631548 Alan Snappy 27
839139 Maria Foster 57

Question

From the following table, write a SQL query to count the number of employees in each department. Return department code and number of employees.  
 
 Sample table: emp_details 
 
  EMP_IDNO EMP_FNAME       EMP_LNAME         EMP_DEPT
--------- --------------- --------------- ----------
   127323 Michale         Robbin                  57
   526689 Carlos          Snares                  63
   843795 Enric           Dosio                   57
   328717 Jhon            Snares                  63
   444527 Joseph          Dosni                   47
   659831 Zanifer         Emily                   47
   847674 Kuleswar        Sitaraman               57
   748681 Henrey          Gabriel                 47
   555935 Alex            Manuel                  57
   539569 George          Mardy                   27
   733843 Mario           Saule                   63
   631548 Alan            Snappy                  27
   839139 Maria           Foster                  57

Answer

SELECT COUNT(*)
  FROM emp_details
  GROUP BY emp_dept;

Answer

SELECT emp_dept, COUNT(*)
  FROM emp_details
  GROUP BY emp_dept;

Answer

SELECT emp_dept, COUNT(*)
  FROM emp_details SORT BY emp_idno;

Answer

SELECT emp_dept FROM emp_details
  GROUP BY emp_dept HAVING COUNT(emp_dept)

Crowdly

From the following table, write a SQL query to count the number of employees in ...

Want instant access to all verified answers on moodle.astanait.edu.kz?