CompTIA DA0-002 Question Answer
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:
Employee_ID
Level
Salary
001
1
10000
002
2
20000
003
2
256000
004
2
125000
001
1
10000
002
2
20000
Which of the following SQL statements resolves this issue?