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

For each duplicate-email group, return: email, total_occurrences, different_depts (distinct department_ids in the group), salary_variations (distinct salaries in the group). A high count of distinct values within a duplicate group flags data-entry inconsistency. Order by total_occurrences DESC, email.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

GROUP BY FundamentalsAggregate Functions & Grouping
HAVING ClauseAggregate Functions & Grouping
DISTINCT & Removing DuplicatesSQL Fundamentals