SQL Practice Logo

SQLPractice Online

Scenario SQL Question

Find Duplicate Email Addresses

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

Problem Statement

Write a query to find all email addresses that appear more than once in the employees table. Return email address and count of occurrences.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics: