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 vote136 views2 answers
How to tun mysql on ubunto
SQL
6 votes141 views2 answers
How to get yesterday date in mysql
SQL
0 vote145 views1 answer
Get the previous column of a table in mysql
SQL
0 vote95 views1 answer
Delete all rows from table sqlite
SQL
3 votes166 views1 answer
Apex set debug level
SQL
0 vote143 views1 answer
Restore backup mysql .gz
SQL
0 vote158 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
0 vote128 views1 answer
Minecraft duping allowed servers
SQL
1 vote216 views1 answer
Create new table from old table with data
SQL
1 vote466 views1 answer
Mysql event last execution
SQL