SURNAME_ADMISSION NUMBER

chioma_adande · updated December 06, 2021 · SQL
CREATE TABLE IF NOT EXISTS Worker
(
WORKER_ID INT,
FIRST_NAME CHAR(25),
LAST_NAME CHAR(25),
SALARY INT(15),
JOINING_DATE DATETIME,
DEPARTMENT CHAR(25)
);

INSERT INTO Worker
(WORKER_ID,FIRST_NAME,LAST_NAME,SALARY,JOINING_DATE,DEPARTMENT)
values        
('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');
SELECT * FROM Worker;
 SELECT * FROM Worker WHERE FIRST_NAME LIKE '%v%';
 SELECT * FROM Worker WHERE FIRST_NAME LIKE '%Vipul%';
SELECT * FROM Worker WHERE FIRST_NAME LIKE '%Satish%';
select * from Worker WHERE FIRST_NAME LIKE '%a%';
CREATE TABLE IF NOT EXISTS Bonus
(
WORKER_REF_ID INT,
BONUS_AMOUNT INT(10),
BONUS_DATE DATETIME,
FOREIGN KEY(WORKER_REF_ID)
REFERENCES Worker(worker_id)
ON DELETE CASCADE
);

INSERT INTO Bonus
(WORKER_REF_ID,BONUS_AMOUNT,BONUS_DATE)
values
('001','5000','16-02-20'),
('002','300','16-06-11'),
('003','4000','16-02-20'),
('004','4500','16-02-20'),
('005','3500','16-06-11');
SELECT * FROM Bonus;
CREATE TABLE IF NOT EXISTS Workerinfo
(
WORKER_REF_ID INT,
WORKER_TITLE CHAR(25),
AFFECTED_FROM DATETIME,
FOREIGN KEY(WORKER_REF_ID)
REFERENCES Worker(WORKER_ID)
ON DELETE CASCADE
);

INSERT INTO Workerinfo
(WORKER_REF_ID,WORKER_TITLE,AFFECTED_FROM)
values
('001','Manager','2016-02-20 00:00:00'),
('002','Executive','2016-06-11 00:00:00'),
('008,'Executive','2016-06-11 00:00:00'),
('005','Manager','2016-06-11 00:00:00'),
('004','Asst.Manager','2016-06-11 00:00:00'),
('007','Executive','2016-06-11 00:00:00'),
('006','Lead','2016-06-11 00:00:00'),
('003','Lead','2016-06-11 00:00:00');
SELECT * FROM Workerinfo;



Comments

Please sign up or log in to contribute to the discussion.