Dear Collegues,
I need your help, I have a list of 1000 employees. I need to pay them an increase of 3% on their salary as per the following criteria:
<tbody>
</tbody>
I need your help, I have a list of 1000 employees. I need to pay them an increase of 3% on their salary as per the following criteria:
- All employee to get 3% increase BUT
- If the salary is <300 and Year of Services > 3 years the MIN increase should be $15
- If the salary is <300 and Year of Services < 3 years the MIN increase should be $10
- All other should get 3%
SALARY | JOIN_DATE |
233 | 3-Oct-99 |
350 | 1-Mar-03 |
400 | 9-May-99 |
300 | 2-Jul-00 |
174 | 1-Jun-09 |
242 | 21-Nov-00 |
203 | 10-Jul-05 |
500 | 14-Oct-12 |
600 | 5-Apr-06 |
301 | 25-Jul-04 |
700 | 27-Jun-10 |
214 | 5-Apr-06 |
174 | 19-Jul-09 |
190 | 2-May-06 |
234 | 7-Jan-01 |
200 | 5-Apr-06 |
197 | 11-Dec-05 |
602 | 30-Mar-72 |
573 | 18-May-75 |
409 | 2-Oct-90 |
492 | 14-Nov-85 |
385 | 26-Oct-76 |
457 | 11-Aug-79 |
300 | 13-May-01 |
<tbody>
</tbody>