Add new column for each task
1 Write 'Eligible for Gift', in front of Females having Salary less than 50000
2 Employees having Salary less than 30000 and belong to CCD department, Get 9000 as Bonus
3 Employees joined before 1980 , write them as 'Retired'
4 Employees belong to Sales or Marketing Department with Basic Salary < 45000 get Bonus of 25000
5 Gift everyone 1500 rs. Amazon Voucher, except Director and CEO
C_Code FirstName LastName Joining Date Gender M_Status Department Basic Salary Region 1 2
150773 Stan Serrao 15-Jul-73 Male Married Finance 85000 North 0 0
150777 Melwyn Crasto 30-Oct-57 Male Married Marketing 22000 North FALSE 0
150784 Sachin Bangera 28-Aug-77 Female Single Digital Marketing 35000 North Eligible for gift 0
150791 Rajesh Bohra 1-Dec-63 Female Married Digital Marketing 67000 South FALSE 0
150798 Tulsidas Shetty 31-May-77 Female Married Digital Marketing 81000 North FALSE 0
150805 Rajesh Dedhia 27-Aug-71 Male Married Director 91000 North FALSE 0
150814 Heena Dongre 9-Nov-71 Male Married Inside Sales 50000 Mid West FALSE 0
150821 Yashraj Vaidya 15-Jan-82 Male Single CCD 26000 Mid West FALSE 9000
150830 Rajeev Singh 1-Jul-79 Female Married Sales 52000 East FALSE 0
150834 Ram Ambradkar 1-Jun-85 Female Married FLM 48000 North Eligible for gift 0
150840 Piyush Shah 5-May-63 Female Married Inside Sales 20000 South Eligible for gift 0
150850 Dhiren Sheth 7-Sep-87 Male Married CCD 47000 East FALSE 0
150851 Sudesh Pillai 27-May-80 Male Single Inside Sales 75000 East FALSE 0
150858 Jagjit Kahlon 27-May-95 Male Married CCD 34000 East FALSE 0
150865 Ruffina Joshi 20-Aug-85 Female Married CEO 90000 South FALSE 0
150867 Boneca Rego 22-Jun-79 Female Single Finance 49000 South Eligible for gift 0
150874 Venitha Shetty 26-Sep-03 Female Married Marketing 27000 South Eligible for gift 0
150881 Dinesh Dhanuka 21-Jan-83 Male Single Digital Marketing 92000 South FALSE 0
150888 Gururaj Joshi 1-Jan-80 Male Married Learning & Devel 43000 Mid West FALSE 0
150894 D Kulkarni 21-Aug-01 Male Married Inside Sales 67000 South FALSE 0
150899 Sharadcha Riswadkar 24-May-02 Male Married CCD 50000 South FALSE 0
150901 Ashok Samtaney 14-Mar-90 Female Married Sales 53000 East FALSE 0
150905 Yogesh Mansharam17-May-84 Female Single FLM 62000 East FALSE 0
150912 Nitin Patki 8-Jan-03 Female Married Operations 81000 South FALSE 0
150921 Prem Pherwani 15-Apr-04 Male Married Finance 19000 Mid West FALSE 0
150929 Bobby Tanna 16-Mar-73 Male Married Marketing 58000 South FALSE 0
150930 Piyush Kamdar 16-May-01 Male Married Digital Marketing 82000 South FALSE 0
150937 Dhiren Haria 16-Aug-67 Male Married Learning & Devel 37000 North FALSE 0
150940 Rajeesh C 30-Aug-73 Male Single Inside Sales 87000 East FALSE 0
150947 Raju Manek 30-Jul-91 Female Married CCD 85000 East FALSE 0
150954 Kawdoor Shetty 6-Mar-97 Female Married Sales 57000 South FALSE 0
150962 Shankar Shetty 1-Jun-03 Female Married Director 87000 South FALSE 0
150968 Praful Savla 13-Nov-01 Male Married Operations 65000 East FALSE 0
150975 Simon Rodrigues 7-Mar-86 Male Married Finance 83000 North FALSE 0
150982 Jitendra Thacker 24-May-97 Male Married Marketing 47000 North FALSE 0
150989 Vishnu Desai 28-Aug-90 Male Married Digital Marketing 45000 South FALSE 0
150990 Dattatray Desai 28-Aug-99 Male Married Learning & Devel 77000 Mid West FALSE 0
150995 Satish Pasari 22-Sep-96 Male Married Inside Sales 15000 North 0
3 4 5
Retired 0 1500
Retired 25000 1500
Retired 0 1500
Retired 0 1500
Retired 0 1500
Retired 0 0
Retired 0 1500
Not Retired 0 1500
Retired 0 1500
Not Retired 0 1500
Retired 0 1500
Not Retired 0 1500
Not Retired 0 1500
Not Retired 0 1500
Not Retired 0 0
Retired 0 1500
Not Retired 25000 1500
Not Retired 0 1500
Not Retired 0 1500
Not Retired 0 1500
Not Retired 0 1500
Not Retired 0 1500
Not Retired 0 1500
Not Retired 0 1500
Not Retired 0 1500
Retired 0 1500
Not Retired 0 1500
Retired 0 1500
Retired 0 1500
Not Retired 0 1500
Not Retired 0 1500
Not Retired 0 0
Not Retired 0 1500
Not Retired 0 1500
Not Retired 0 1500
Not Retired 0 1500
Not Retired 0 1500
Not Retired 0 1500
