Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
1.0 kB
2
Indexable
(001, 'Monika', 'Arora', 100000, '14-02-20 09.00.00', 'HR'),

(002, 'Niharika', 'Verma', 80000, '14-06-11 09.00.00', 'Admin'),

(003, 'Vishal', 'Singhal', 300000, '14-02-20 09.00.00', 'HR'),

(004, 'Amitabh', 'Singh', 500000, '14-02-20 09.00.00', 'Admin'),

(005, 'Vivek', 'Bhati', 500000, '14-06-11 09.00.00', 'Admin'),

(006, 'Vipul', 'Diwan', 200000, '14-06-11 09.00.00', 'Account'), (007, 'Satish', 'Kumar', 75000, '14-01-20 09.00.00', 'Account'),

(008, 'Geetika', 'Chauhan', 90000, '14-04-11 09.00.00', 'Admin');


INSERT INTO Bonus

-37

(WORKER REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES

38

(001, 5000, '16-02-20'),

39

(002, 3000, '16-06-11'),

40

(003, 4000, '16-02-20'),

41

(001, 4500, '16-02-20'),

42

(002, 3500, '16-06-11');



INSERT INTO Bonus

(WORKER_REF_ID, BONUS AMOUNT, BONUS_DATE) VALUES

(001, 5000, '16-02-20'),

(002, 3000, '16-06-11'),

(003, 4000, '16-02-20'),

(001, 4500, '16-02-20'),

(002, 3500, '16-06-11');


INSERT INTO Worker

(WORKER ID, FIRST NAME, LAST_NAME, SALARY, JOINING DATE, DEPARTMENT) VALUES