Employee salary history

Question

You are given the following table containing historical employee salaries for company XYZ:

Table: EmployeeSalaries

employee_ID salary year
1 80000 2020
1 70000 2019
1 60000 2018
2 65000 2020
2 65000 2019
2 60000 2018
3 65000 2019
3 60000 2018

Given the above table, can you write a SQL query to return the employees who have received at least 3 year over year raises based on the table's data?

Solution

Access restricted

Subscribe to premium account to see the solution.

Get premium now