Scenario SQL Question
Find Data Completeness Score by Email Group
Build mastery in Finding Duplicates with this scenario-based SQL challenge and live execution support.
Problem Statement
For each duplicate-email group, compute the data-completeness percentage across THREE critical columns (salary, department_id, manager_id). The score is `non_null_fields / (3 * row_count) * 100`, rounded to 2 decimals. Return email, duplicate_count, completeness_pct, ordered by completeness_pct ASC (worst quality first).
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: