Scenario SQL Question

Find All Records with Duplicate First Names

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

Problem Statement

Find every (first_name, last_name) pair that appears more than once across employees. Return first_name, last_name, and name_count, ordered by name_count DESC then first_name.

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