Scenario SQL Question
Analyze Duplicate Patterns and Data Inconsistencies
Build mastery in Finding Duplicates with this scenario-based SQL challenge and live execution support.
Problem Statement
Write a query to analyze duplicate emails: show email, occurrence count, and how many different department_ids exist for each duplicate group. This identifies data consistency issues.
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: