Scenario SQL Question
All Departments with Employee Count
Build mastery in Joins with this scenario-based SQL challenge and live execution support.
Problem Statement
Show all departments and their employee count using LEFT JOIN (include departments with no employees).
Relevant Tables
departmentsemployees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: