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 "singer" VALUES ("11", "Lady Gaga", "1986", "320");
INSERT INTO "singer" VALUES ("12", "The Weeknd", "1990", "100");
INSERT INTO "singer" VALUES ("13", "Billie Eilish", "2001", "53");
INSERT INTO "singer" VALUES ("14", "Harry Styles", "1994", "120");
INSERT INTO "singer" VALUES ("15", "Dua Lipa", "1995", "35");
INSERT INTO "singer" VALUES ("16", "Shawn Mendes", "1998", "40");
INSERT INTO "singer" VALUES ("17", "Camila Cabello", "1997", "18");
INSERT INTO "singer" VALUES ("18", "Post Malone", "1995", "60");
INSERT INTO "singer" VALUES ("19", "Travis Scott", "1991", "80");
INSERT INTO "singer" VALUES ("20", "Cardi B", "1992", "40");
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", "1");
INSERT INTO "song" VALUES ("5", "12000000", "1");
INSERT INTO "song" VALUES ("6", "6000000", "2");
INSERT INTO "song" VALUES ("7", "4000000", "3");
INSERT INTO "song" VALUES ("8", "9000000", "1");
INSERT INTO "song" VALUES ("9", "7500000", "1");
INSERT INTO "song" VALUES ("10", "3000000", "5");
INSERT INTO "song" VALUES ("11", "5500000", "2");
INSERT INTO "song" VALUES ("12", "2000000", "10");
INSERT INTO "song" VALUES ("13", "1500000", "7");
INSERT INTO "song" VALUES ("14", "2500000", "4");
INSERT INTO "song" VALUES ("15", "1000000", "15");
INSERT INTO "song" VALUES ("16", "800000", "20");
INSERT INTO "song" VALUES ("17", "500000", "25");
INSERT INTO "song" VALUES ("18", "3000000", "6");
INSERT INTO "song" VALUES ("19", "4500000", "3");
INSERT INTO "song" VALUES ("20", "2000000", "8");