← Swiggy questions
CodingReported in a candidate post, Jul 2025

Department-wise employee counts including empty departments

Filed under Swiggy

Given Employee(id, name, department_id) and Department(id, name) tables, write a SQL query that returns each department name with its number of employees, including departments with zero employees…

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related Swiggy questions

Collected from public candidate posts and coding forums. Updated Nov 2026.