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 "singer" (
"Singer_ID" INT UNIQUE,
"Citizenship" TEXT,
PRIMARY KEY ("Singer_ID")
);

CREATE TABLE "song" (
"Song_ID" INT,
"Singer_ID" INT,
"Sales" FLOAT,
"Highest_Position" FLOAT,
PRIMARY KEY ("Song_ID"),
FOREIGN KEY ("Singer_ID") REFERENCES "singer"("Singer_ID")
);





INSERT INTO "singer" VALUES ("1", "USA");
INSERT INTO "singer" VALUES ("2", "Canada");
INSERT INTO "singer" VALUES ("3", "USA");
INSERT INTO "singer" VALUES ("4", "UK");
INSERT INTO "singer" VALUES ("5", "France");
INSERT INTO "singer" VALUES ("6", "Canada");
INSERT INTO "singer" VALUES ("7", "Germany");
INSERT INTO "singer" VALUES ("8", "USA");
INSERT INTO "singer" VALUES ("9", "France");
INSERT INTO "singer" VALUES ("10", "UK");
INSERT INTO "singer" VALUES ("11", "Canada");
INSERT INTO "singer" VALUES ("12", "USA");
INSERT INTO "singer" VALUES ("13", "Italy");
INSERT INTO "singer" VALUES ("14", "France");
INSERT INTO "singer" VALUES ("15", "Brazil");
INSERT INTO "singer" VALUES ("16", "Canada");
INSERT INTO "singer" VALUES ("17", "USA");
INSERT INTO "singer" VALUES ("18", "UK");
INSERT INTO "singer" VALUES ("19", "USA");
INSERT INTO "singer" VALUES ("20", "Japan");
INSERT INTO "singer" VALUES ("21", "Canada");
INSERT INTO "singer" VALUES ("22", "USA");
INSERT INTO "singer" VALUES ("23", "France");
INSERT INTO "singer" VALUES ("24", "UK");
INSERT INTO "singer" VALUES ("25", "USA");
INSERT INTO "singer" VALUES ("26", "Canada");
INSERT INTO "singer" VALUES ("27", "USA");
INSERT INTO "singer" VALUES ("28", "Brazil");
INSERT INTO "singer" VALUES ("29", "UK");
INSERT INTO "singer" VALUES ("30", "USA");
INSERT INTO "singer" VALUES ("31", "Canada");
INSERT INTO "singer" VALUES ("32", "USA");
INSERT INTO "singer" VALUES ("33", "France");
INSERT INTO "singer" VALUES ("34", "UK");
INSERT INTO "singer" VALUES ("35", "USA");
INSERT INTO "singer" VALUES ("36", "Canada");
INSERT INTO "singer" VALUES ("37", "USA");
INSERT INTO "singer" VALUES ("38", "Italy");
INSERT INTO "singer" VALUES ("39", "UK");
INSERT INTO "singer" VALUES ("40", "USA");
INSERT INTO "singer" VALUES ("41", "Canada");
INSERT INTO "singer" VALUES ("42", "USA");
INSERT INTO "singer" VALUES ("43", "France");
INSERT INTO "singer" VALUES ("44", "UK");
INSERT INTO "singer" VALUES ("45", "USA");
INSERT INTO "singer" VALUES ("46", "Canada");
INSERT INTO "singer" VALUES ("47", "USA");
INSERT INTO "singer" VALUES ("48", "Brazil");
INSERT INTO "singer" VALUES ("49", "UK");
INSERT INTO "singer" VALUES ("50", "USA");
INSERT INTO "song" VALUES ("1", "1", "50000", "1");
INSERT INTO "song" VALUES ("2", "3", "30000", "5");
INSERT INTO "song" VALUES ("3", "6", "45000", "3");
INSERT INTO "song" VALUES ("4", "8", "20000", "10");
INSERT INTO "song" VALUES ("5", "10", "15000", "15");
INSERT INTO "song" VALUES ("6", "12", "60000", "2");
INSERT INTO "song" VALUES ("7", "15", "10000", "20");
INSERT INTO "song" VALUES ("8", "17", "35000", "7");
INSERT INTO "song" VALUES ("9", "20", "25000", "12");
INSERT INTO "song" VALUES ("10", "22", "40000", "4");
INSERT INTO "song" VALUES ("11", "25", "55000", "1");
INSERT INTO "song" VALUES ("12", "27", "30000", "6");
INSERT INTO "song" VALUES ("13", "30", "45000", "3");
INSERT INTO "song" VALUES ("14", "32", "20000", "9");
INSERT INTO "song" VALUES ("15", "35", "15000", "14");
INSERT INTO "song" VALUES ("16", "37", "60000", "2");
INSERT INTO "song" VALUES ("17", "40", "10000", "18");
INSERT INTO "song" VALUES ("18", "42", "35000", "8");
INSERT INTO "song" VALUES ("19", "45", "25000", "11");
INSERT INTO "song" VALUES ("20", "47", "40000", "5");