Solved programming problem

For each job_id, show the no of employees in that job type from the employees table

Source code

SELECT JOB_ID, COUNT(EMPLOYEE_ID)

FROM employees

GROUP BY JOB_ID;
Join the discussion

Add your comment