Solved programming problem

For each year and each month show the total no of employees who have left their jobs from the job_history table

Source code

SELECT YEAR(END_DATE), MONTH(END_DATE), COUNT(*)

FROM job_history

GROUP BY YEAR(END_DATE),MONTH(END_DATE);
Join the discussion

Add your comment