Group by join columns per table

SELECT 
    e.department_id,
    department_name,
    e.job_id,
    job_title,
    COUNT(employee_id)
FROM
    employees e
        INNER JOIN
    departments d ON d.department_id = e.department_id
        INNER JOIN
    jobs j ON j.job_id = e.job_id
GROUP BY e.department_id , e.job_id;
Code language: SQL (Structured Query Language) (sql)

Source: sqltutorial.org

Similar codes

0 vote142 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote118 views1 answer
Postgres create database if not exists
SQL
0 vote166 views1 answer
Mysql dump with table query
SQL
0 vote106 views1 answer
Mysql workbench search all tables
SQL
0 vote138 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
31 votes156 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote139 views1 answer
Oracle create job if not exists
SQL
1 vote143 views1 answer
Select if then postgresql
SQL
0 vote152 views2 answers
List all constraints in postgres
SQL
1 vote130 views1 answer
Real world example of nosql
SQL