Scenario SQL Question

Count Total Duplicate Email Addresses

Build mastery in Finding Duplicates with this scenario-based SQL challenge and live execution support.

Problem Statement

How many distinct email addresses appear more than once? (Note: this is the count of duplicate GROUPS, not the count of duplicate rows.) Return a single column total_duplicate_emails.

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