MySQL Aggregate Function Exercises: Get the number of employees with the same job

MySQL Aggregate Function: Exercise-7 with Solution

Write a query to get the number of employees with the same job.

Sample table: employees

Code:

SELECT job_id, COUNT(*)
FROM employees
GROUP BY job_id;

Relational Algebra Expression:

Relational Algebra Tree:

Pictorial Presentation of the above query

MySQL Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous:Write a query to get the highest, lowest, sum, and average salary of all employees.
Next:Write a query to get the difference between the highest and lowest salaries.