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

7 votes395 views1 answer
Mysql remote connection command line
SQL
1 vote365 views1 answer
SQL: merging multiple row data in string
SQL
0 vote350 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote337 views1 answer
Sql right characters
SQL
0 vote363 views1 answer
Python connect microsoft sql server
SQL
0 vote312 views1 answer
How to check oracle index table
SQL
0 vote337 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote387 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote355 views1 answer
Mysql grant access to one database
SQL
27 votes373 views6 answers
Set password mysql
SQL