Joined Employee Details

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

easy

Seniority

senior

Problem

The people analytics team needs every employee's name alongside their total metric value from employee_metrics, matched on department. Employees whose department has no metrics recorded yet should still appear with a zero, not be dropped from the results.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.