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,
"Sales" FLOAT,
"Highest_Position" FLOAT,
PRIMARY KEY ("Song_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", "Bob Dylan", "1941");
INSERT INTO "singer" VALUES ("7", "Paul McCartney", "1942");
INSERT INTO "singer" VALUES ("8", "Stevie Wonder", "1949");
INSERT INTO "singer" VALUES ("9", "Jimi Hendrix", "1942");
INSERT INTO "singer" VALUES ("10", "Janis Joplin", "1943");
INSERT INTO "singer" VALUES ("11", "Freddie Mercury", "1946");
INSERT INTO "singer" VALUES ("12", "Bruce Springsteen", "1949");
INSERT INTO "singer" VALUES ("13", "Jim Morrison", "1943");
INSERT INTO "singer" VALUES ("14", "Tina Turner", "1939");
INSERT INTO "singer" VALUES ("15", "George Harrison", "1943");
INSERT INTO "singer" VALUES ("16", "Ray Charles", "1930");
INSERT INTO "singer" VALUES ("17", "Janet Jackson", "1966");
INSERT INTO "singer" VALUES ("18", "Elton John", "1947");
INSERT INTO "singer" VALUES ("19", "Billy Joel", "1949");
INSERT INTO "singer" VALUES ("20", "Paul Simon", "1941");
INSERT INTO "song" VALUES ("1", "Like a Rolling Stone", "8000000", "1");
INSERT INTO "song" VALUES ("2", "Respect", "6000000", "1");
INSERT INTO "song" VALUES ("3", "Imagine", "7000000", "1");
INSERT INTO "song" VALUES ("4", "Satisfaction", "5000000", "1");
INSERT INTO "song" VALUES ("5", "Space Oddity", "4000000", "5");
INSERT INTO "song" VALUES ("6", "Blowin' in the Wind", "3000000", "2");
INSERT INTO "song" VALUES ("7", "Hey Jude", "9000000", "1");
INSERT INTO "song" VALUES ("8", "Superstition", "3500000", "3");
INSERT INTO "song" VALUES ("9", "Purple Haze", "2500000", "4");
INSERT INTO "song" VALUES ("10", "Piece of My Heart", "2000000", "7");
INSERT INTO "song" VALUES ("11", "Bohemian Rhapsody", "10000000", "1");
INSERT INTO "song" VALUES ("12", "Born to Run", "4500000", "2");
INSERT INTO "song" VALUES ("13", "Light My Fire", "3000000", "3");
INSERT INTO "song" VALUES ("14", "Proud Mary", "4000000", "4");
INSERT INTO "song" VALUES ("15", "Something", "3500000", "5");
INSERT INTO "song" VALUES ("16", "Georgia on My Mind", "1500000", "6");
INSERT INTO "song" VALUES ("17", "Rhythm Nation", "5000000", "1");
INSERT INTO "song" VALUES ("18", "Rocket Man", "6000000", "2");
INSERT INTO "song" VALUES ("19", "Piano Man", "7000000", "1");
INSERT INTO "song" VALUES ("20", "The Sound of Silence", "5500000", "3");