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

CREATE TABLE "song" (
"Song_ID" INT,
"Sales" FLOAT,
"Highest_Position" FLOAT,
PRIMARY KEY ("Song_ID")
);





INSERT INTO "singer" VALUES ("1", "Adele", "1988", "220");
INSERT INTO "singer" VALUES ("2", "Ed Sheeran", "1991", "200");
INSERT INTO "singer" VALUES ("3", "Taylor Swift", "1989", "400");
INSERT INTO "singer" VALUES ("4", "Beyonce", "1981", "500");
INSERT INTO "singer" VALUES ("5", "Rihanna", "1988", "1700");
INSERT INTO "singer" VALUES ("6", "Justin Bieber", "1994", "300");
INSERT INTO "singer" VALUES ("7", "Ariana Grande", "1993", "240");
INSERT INTO "singer" VALUES ("8", "Drake", "1986", "250");
INSERT INTO "singer" VALUES ("9", "Katy Perry", "1984", "330");
INSERT INTO "singer" VALUES ("10", "Bruno Mars", "1985", "175");
INSERT INTO "song" VALUES ("1", "5000000", "1");
INSERT INTO "song" VALUES ("2", "7000000", "1");
INSERT INTO "song" VALUES ("3", "10000000", "1");
INSERT INTO "song" VALUES ("4", "8000000", "2");
INSERT INTO "song" VALUES ("5", "12000000", "1");
INSERT INTO "song" VALUES ("6", "6000000", "3");
INSERT INTO "song" VALUES ("7", "9000000", "1");
INSERT INTO "song" VALUES ("8", "7500000", "2");
INSERT INTO "song" VALUES ("9", "11000000", "1");
INSERT INTO "song" VALUES ("10", "5500000", "4");