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
Write a query to find duplicate emails and calculate data completeness percentage (% of non-NULL fields) for each duplicate group.
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: