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

Write a query to count how many email addresses have duplicates in the employees table (not the count per email, but total distinct 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