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

1 vote205 views1 answer
Mysql strict_trans_tables
SQL
0 vote201 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
-2 votes198 views3 answers
Sqlite reset autoincrement
SQL
3 votes325 views1 answer
Sql add two values together
SQL
0 vote203 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
17 votes219 views1 answer
Selecting name that contain certain word in sql
SQL
12 votes205 views5 answers
Sql primary key
SQL
2 votes194 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote191 views1 answer
Sql last 7 days
SQL
10 votes222 views4 answers
Join multiple tables in sql
SQL