Problem Statement

HR is auditing the employees table and wants to find every email address that appears more than once. Return email and the occurrence_count, ordered so the most-duplicated emails come first (then alphabetically as a tie-breaker).

Relevant Tables