PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "employee" (
"Employee_ID" INT UNIQUE,
"Age" INT,
"City" TEXT,
PRIMARY KEY ("Employee_ID")
);

CREATE TABLE "hiring" (
"Shop_ID" INT,
"Employee_ID" INT,
"Start_from" TEXT,
PRIMARY KEY ("Employee_ID"),
FOREIGN KEY ("Shop_ID") REFERENCES "shop"("Shop_ID")
);

CREATE TABLE "shop" (
"Shop_ID" INT,
"Location" TEXT,
PRIMARY KEY ("Shop_ID")
);





INSERT INTO "employee" VALUES ("1", "25", "New York");
INSERT INTO "employee" VALUES ("2", "29", "New York");
INSERT INTO "employee" VALUES ("3", "22", "Los Angeles");
INSERT INTO "employee" VALUES ("4", "31", "Los Angeles");
INSERT INTO "employee" VALUES ("5", "28", "Chicago");
INSERT INTO "employee" VALUES ("6", "35", "Chicago");
INSERT INTO "employee" VALUES ("7", "27", "Houston");
INSERT INTO "employee" VALUES ("8", "45", "Houston");
INSERT INTO "employee" VALUES ("9", "19", "Phoenix");
INSERT INTO "employee" VALUES ("10", "40", "Phoenix");
INSERT INTO "employee" VALUES ("11", "33", "Philadelphia");
INSERT INTO "employee" VALUES ("12", "26", "Philadelphia");
INSERT INTO "employee" VALUES ("13", "24", "San Antonio");
INSERT INTO "employee" VALUES ("14", "23", "San Antonio");
INSERT INTO "employee" VALUES ("15", "29", "San Diego");
INSERT INTO "employee" VALUES ("16", "50", "Dallas");
INSERT INTO "employee" VALUES ("17", "21", "Dallas");
INSERT INTO "employee" VALUES ("18", "22", "San Jose");
INSERT INTO "employee" VALUES ("19", "28", "San Jose");
INSERT INTO "employee" VALUES ("20", "31", "Austin");
INSERT INTO "employee" VALUES ("21", "29", "Austin");
INSERT INTO "employee" VALUES ("22", "27", "Jacksonville");
INSERT INTO "employee" VALUES ("23", "34", "Jacksonville");
INSERT INTO "employee" VALUES ("24", "18", "Fort Worth");
INSERT INTO "employee" VALUES ("25", "45", "Fort Worth");
INSERT INTO "employee" VALUES ("26", "29", "Columbus");
INSERT INTO "employee" VALUES ("27", "29", "Columbus");
INSERT INTO "employee" VALUES ("28", "30", "Charlotte");
INSERT INTO "employee" VALUES ("29", "22", "Charlotte");
INSERT INTO "employee" VALUES ("30", "40", "San Francisco");
INSERT INTO "shop" VALUES ("1", "New York");
INSERT INTO "shop" VALUES ("2", "Los Angeles");
INSERT INTO "shop" VALUES ("3", "Chicago");
INSERT INTO "shop" VALUES ("4", "Houston");
INSERT INTO "shop" VALUES ("5", "Phoenix");
INSERT INTO "shop" VALUES ("6", "Philadelphia");
INSERT INTO "shop" VALUES ("7", "San Antonio");
INSERT INTO "shop" VALUES ("8", "San Diego");
INSERT INTO "shop" VALUES ("9", "Dallas");
INSERT INTO "shop" VALUES ("10", "San Jose");
INSERT INTO "shop" VALUES ("11", "Austin");
INSERT INTO "shop" VALUES ("12", "Jacksonville");
INSERT INTO "shop" VALUES ("13", "Fort Worth");
INSERT INTO "shop" VALUES ("14", "Columbus");
INSERT INTO "shop" VALUES ("15", "Charlotte");
INSERT INTO "shop" VALUES ("16", "San Francisco");
INSERT INTO "hiring" VALUES ("1", "1", "2020-01-15");
INSERT INTO "hiring" VALUES ("1", "2", "2021-03-20");
INSERT INTO "hiring" VALUES ("2", "3", "2019-07-10");
INSERT INTO "hiring" VALUES ("2", "4", "2018-05-05");
INSERT INTO "hiring" VALUES ("3", "5", "2022-02-28");
INSERT INTO "hiring" VALUES ("3", "6", "2017-11-11");
INSERT INTO "hiring" VALUES ("4", "7", "2020-06-01");
INSERT INTO "hiring" VALUES ("4", "8", "2016-09-09");
INSERT INTO "hiring" VALUES ("5", "9", "2021-12-12");
INSERT INTO "hiring" VALUES ("5", "10", "2015-04-04");
INSERT INTO "hiring" VALUES ("6", "11", "2019-08-08");
INSERT INTO "hiring" VALUES ("6", "12", "2020-10-10");
INSERT INTO "hiring" VALUES ("7", "13", "2021-01-01");
INSERT INTO "hiring" VALUES ("7", "14", "2022-03-03");
INSERT INTO "hiring" VALUES ("8", "15", "2018-07-07");
INSERT INTO "hiring" VALUES ("9", "16", "2017-05-05");
INSERT INTO "hiring" VALUES ("9", "17", "2019-09-09");
INSERT INTO "hiring" VALUES ("10", "18", "2020-11-11");
INSERT INTO "hiring" VALUES ("10", "19", "2021-12-12");
INSERT INTO "hiring" VALUES ("11", "20", "2018-02-02");
INSERT INTO "hiring" VALUES ("11", "21", "2019-03-03");
INSERT INTO "hiring" VALUES ("12", "22", "2020-04-04");
INSERT INTO "hiring" VALUES ("12", "23", "2021-05-05");
INSERT INTO "hiring" VALUES ("13", "24", "2022-06-06");
INSERT INTO "hiring" VALUES ("13", "25", "2017-07-07");
INSERT INTO "hiring" VALUES ("14", "26", "2018-08-08");
INSERT INTO "hiring" VALUES ("14", "27", "2019-09-09");
INSERT INTO "hiring" VALUES ("15", "28", "2020-10-10");
INSERT INTO "hiring" VALUES ("15", "29", "2021-11-11");
INSERT INTO "hiring" VALUES ("16", "30", "2022-12-12");