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,
"Name" TEXT,
"Birth_Year" FLOAT,
PRIMARY KEY ("Singer_ID")
);

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





INSERT INTO "singer" VALUES ("1", "Elvis Presley", "1935");
INSERT INTO "singer" VALUES ("2", "Aretha Franklin", "1942");
INSERT INTO "singer" VALUES ("3", "John Lennon", "1940");
INSERT INTO "singer" VALUES ("4", "Mick Jagger", "1943");
INSERT INTO "singer" VALUES ("5", "David Bowie", "1947");
INSERT INTO "singer" VALUES ("6", "Paul McCartney", "1942");
INSERT INTO "singer" VALUES ("7", "Bob Dylan", "1941");
INSERT INTO "singer" VALUES ("8", "Freddie Mercury", "1946");
INSERT INTO "singer" VALUES ("9", "Stevie Wonder", "1949");
INSERT INTO "singer" VALUES ("10", "Janis Joplin", "1948");
INSERT INTO "singer" VALUES ("11", "Jim Morrison", "1943");
INSERT INTO "singer" VALUES ("12", "Jimi Hendrix", "1942");
INSERT INTO "singer" VALUES ("13", "Bruce Springsteen", "1949");
INSERT INTO "singer" VALUES ("14", "Kurt Cobain", "1967");
INSERT INTO "singer" VALUES ("15", "Adele", "1988");
INSERT INTO "song" VALUES ("1", "Hound Dog", "1", "1000000");
INSERT INTO "song" VALUES ("2", "Respect", "2", "1500000");
INSERT INTO "song" VALUES ("3", "Imagine", "3", "2000000");
INSERT INTO "song" VALUES ("4", "Satisfaction", "4", "1800000");
INSERT INTO "song" VALUES ("5", "Space Oddity", "5", "1200000");
INSERT INTO "song" VALUES ("6", "Hey Jude", "6", "2500000");
INSERT INTO "song" VALUES ("7", "Like a Rolling Stone", "7", "1300000");
INSERT INTO "song" VALUES ("8", "Bohemian Rhapsody", "8", "3000000");
INSERT INTO "song" VALUES ("9", "Superstition", "9", "1100000");
INSERT INTO "song" VALUES ("10", "Piece of My Heart", "10", "900000");
INSERT INTO "song" VALUES ("11", "Light My Fire", "11", "850000");
INSERT INTO "song" VALUES ("12", "Purple Haze", "12", "950000");
INSERT INTO "song" VALUES ("13", "Born to Run", "13", "1400000");
INSERT INTO "song" VALUES ("14", "Smells Like Teen Spirit", "14", "2200000");
INSERT INTO "song" VALUES ("15", "Hello", "15", "2100000");