For each department in employee_metrics, calculate the average metric_value and the median metric_va

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

Domain

SQL

Difficulty

medium

Problem

For each department in employee_metrics, calculate the average metric_value and the median metric_value (50th percentile using APPROX_PERCENTILE). Label them avg_value and median_value.

Practice This Problem

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