Databases SQL Reporting by Example Day 2: Advanced Selecting Day 2: Review

Rashmi Jha
Rashmi Jha
2,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

2 Answers

Stuart Wright
Stuart Wright
41,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
Rashmi Jha
Rashmi Jha
2,842 Points

Thanks, Stuart this is really helpful. Now I know where I got confused.