Scenario SQL Question

Department-Job Matrix with Employee Counts

Build mastery in Joins with this scenario-based SQL challenge and live execution support.

Problem Statement

Build a matrix showing how many employees per department hold each job title. Columns: department_id, department_name, software_developers, it_managers, hr_reps, financial_analysts, marketing_managers, sales_reps. Include EVERY department (Operations included with 0s). Order by department_id.

Relevant Tables

departmentsemployeesjobs

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

INNER JOIN Deep DiveJoins & Relationships
LEFT/RIGHT/FULL OUTER JOINJoins & Relationships
Multiple Table JoinsJoins & Relationships