For each job, show the job_title and total no of employees

SELECT j.JOB_ID,j.JOB_TITLE,COUNT(e.EMPLOYEE_ID)

FROM jobs AS j 

    JOIN 

    employees AS e 

    ON j.JOB_ID = e.JOB_ID 

GROUP BY j.JOB_ID,e.JOB_ID;