The human resources department wants to know the number of employees who earn $125,000 or more. However, the department is concerned about duplicates in the dataset. Given the following table: Which o

This statement selects a list of distinct `Employee_ID` values but does not return a count, which is what the human resources department requested.

The SQL statement `SELECT COUNT(DISTINCT Employee_ID) FROM Employee WHERE Salary >= 125000` correctly addresses both requirements. `COUNT(DISTINCT Employee_ID)` ensures that each unique employee is counted only once, effectively resolving any duplicate entries, and the `WHERE Salary >= 125000` clause filters for employees earning $125,000 or more.

This statement uses `Salary > 125000`, which excludes employees earning exactly $125,000, contradicting the requirement of "$125,000 or more." Additionally, it returns a list of IDs, not a count.

This statement uses `COUNT(Employee_ID)` without `DISTINCT`, meaning it would count all employee IDs that meet the salary criteria, including any duplicates, which goes against the department's concern about duplicates.