EKPU_412

an anonymous user · December 06, 2021 · SQL
CREATE TABLE Worker (
  WORKER_ID INT PRIMARY KEY,
  FISRT_NAME CHAR(25),
  LAST_NAME CHAR(25),
  SALARY INT(15),
  JOINING_DATE DATETIME,
  DEPARTMENT CHAR(25)
);

INSERT INTO Worker (WORKER_ID, FISRT_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", "HR"),
("003", "Vishal", "Singhal", "300000", "14-02-20 09.00.00", "HR"),
("004", "Amitabh", "Singh", "500000", "14-02-20 09.00.00", "HR"),
("005", "Vivek", "Bhati", "500000", "14-06-20 09.00.00", "HR"),
("006", "Vipul", "Diwan", "200000", "14-06-11 09.00.00", "HR"),
("007", "Satish", "Kumar", "75000", "14-01-20 09.00.00", "Account"),
("008", "Greetika", "Arora", "90000", "14-04-11 09.00.00", "HR");

CREATE TABLE Bonus (
WORKER_REF_ID INT,
BONUS_AMOUNT INT(10),
BONUS_DATE DATETIME,
FOREIGN KEY(WORKER_REF_ID)
REFERENCES Worker(WORKER_REF_ID)
ON DELETE CASCADE
);

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"),
("004", "4500", "16-02-20"),
("005", "3500", "16-06-11");

CREATE TABLE Title (
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 Title (WORKER_REF_ID, WORKER_TITLE, AFFECTED_FROM)
VALUES
(001, "Manager", "2016-02-20 00:00:00"),
(002, "Excecutive", "2016-06-11 00:00:00"),
(008, "Excecutive", "2016-06-11 00:00:00"),
(005, "Manager", "2016-06-11 00:00:00"),
(004, " Asst Manager", "2016-02-20 00:00:00"),
(008, "Excecutive", "2016-06-11 00:00:00"),
(008, "Lead", "2016-06-11 00:00:00"),
(003, "Lead", "2016-06-11 00:00:00");


SELECT FIRST_NAME FROM WORKER

SELECT WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT FROM SUPLLIER where
FIRST_NAME LIKE "%V%"
 
 SELECT * FROM TABLE Worker
 
SELECT WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT FROM SUPLLIER where
FIRST_NAME LIKE "%Vipul%"
SELECT WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT FROM SUPLLIER where
FIRST_NAME LIKE "%Satish%"
SELECT WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT FROM SUPLLIER where
FIRST_NAME LIKE "%A"
SELECT WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT FROM SUPLLIER where
FIRST_NAME LIKE "%H"
 SELECT * FROM TABLE Worker
SELECT * FROM TABLE Title
SELECT * FROM TABLE Bonus

_

Comments

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