Untitled

mail@pastecode.io avatar
unknown
plain_text
3 months ago
678 B
2
Indexable
Never
CREATE TABLE Staff(
STAFF_ID VARCHAR(20),
STAFF_TYPE VARCHAR(20),
FIRST_NAME VARCHAR(20),
LAST_NAME VARCHAR(20),
AGE INT,
DOB DATE,
GENDER VARCHAR(10),
JOIN_DATE DATE,
ADDRESS_ID VARCHAR(20)
);

INSERT INTO Staff
VALUES
(1,'Assistant','Sita','Gyawali',24,'2000-4-22','Female','2024-02-02','Kathmandu'),
(1,'CEO','Ram','Pudasaini',44,'1980-4-15','Male','2022-02-24','Lalitpur'),
(1,'Manager','Sita','Rai',42,'1982-7-21','Female','2020-07-03','Bhaktapur'),
(1,'Assistant Manager','Harilal','Balami',35,'1989-4-22','Male','2023-09-24','Kaski'),
(1,'Founder','Binod','Poudel',55,'1968-8-19','Male','1991-02-02','Gorakha')

SELECT * FROM Staff

DROP TABLE Staff
Leave a Comment