Rashmi Jha2,842 Points
Fill in the blanks
Fill in the blank(s) below: Write a query to figure out how many employees are in each job role.
SELECT JOBS.ROLE, COUNT(1) FROM EMPLOYEES JOIN JOBS ON EMPLOYEES.JOB_ID = JOBS.ID
I don't understand question
Stuart Wright41,091 Points
To get the results grouped by job role, you need the following statement at the end of your query:
group by jobs.role