Duplicate Email Frequency

Problem Statement

Problem Description You are given a table of job applicants. Write an SQL query to identify duplicate email addresses. Specifically, fetch each email_id that appears more than once in the table, along with its frequency of occurrence. Sort the final result in ascending alphabetical order by email_id . Schema Table: applicant Column Name Data Type Description applicant_id Integer Primary key. Unique identifier for the applicant. applicant_name VARCHAR Name of the applicant. email_id VARCHAR Email address of the applicant. Required Output Return a table containing the duplicate emails and their frequencies, ordered ascending by email_id . Column Name Data Type Description email_id VARCHAR The duplicate email address. frequency Integer The number of times the email_id appears in the table (must be > 1). Constraints or Notes Allowed Languages: MySQL, PostgreSQL. Time Limit: 5 seconds for each input file. Memory Limit: 256 MB. Examples Example 1 Input Table: applicant applicant_id applic