Practice Microsoft SQL Question | Real Coding Interviews | Hack2hire

NewThe Learning module is now liveSee what's new

Question Bank Learning

Pricing Blog Forum

Quick Summary

Identify departments that contain more than one employee.
Calculate the total number of employees per department.
Return results sorted alphabetically by department name.

What This Tests

Grouping data by categorical columns
Filtering aggregated results using thresholds
Sorting output based on string values
Understanding aggregation scope versus row-level filtering

Common Patterns

Aggregation

HAVING Filter

Groupby

Sort

Test Cases

Input

-

Output

-

Expected

-