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

CREATE TABLE "song" (
"Song_ID" INT,
"Title" TEXT,
"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", "Adele", "220.0");
INSERT INTO "singer" VALUES ("2", "Ed Sheeran", "200.0");
INSERT INTO "singer" VALUES ("3", "Taylor Swift", "400.0");
INSERT INTO "singer" VALUES ("4", "Justin Bieber", "285.0");
INSERT INTO "singer" VALUES ("5", "Beyonce", "500.0");
INSERT INTO "singer" VALUES ("6", "Rihanna", "1700.0");
INSERT INTO "singer" VALUES ("7", "Drake", "250.0");
INSERT INTO "singer" VALUES ("8", "Ariana Grande", "240.0");
INSERT INTO "singer" VALUES ("9", "Bruno Mars", "175.0");
INSERT INTO "singer" VALUES ("10", "Lady Gaga", "320.0");
INSERT INTO "singer" VALUES ("11", "Coldplay", "475.0");
INSERT INTO "singer" VALUES ("12", "Dua Lipa", "35.0");
INSERT INTO "singer" VALUES ("13", "The Weeknd", "100.0");
INSERT INTO "singer" VALUES ("14", "Billie Eilish", "53.0");
INSERT INTO "singer" VALUES ("15", "Shawn Mendes", "40.0");
INSERT INTO "song" VALUES ("101", "Hello", "1", "35000000.0", "1.0");
INSERT INTO "song" VALUES ("102", "Shape of You", "2", "41000000.0", "1.0");
INSERT INTO "song" VALUES ("103", "Blank Space", "3", "12000000.0", "1.0");
INSERT INTO "song" VALUES ("104", "Sorry", "4", "10000000.0", "1.0");
INSERT INTO "song" VALUES ("105", "Single Ladies", "5", "7000000.0", "1.0");
INSERT INTO "song" VALUES ("106", "Umbrella", "6", "6000000.0", "1.0");
INSERT INTO "song" VALUES ("107", "Hotline Bling", "7", "5000000.0", "2.0");
INSERT INTO "song" VALUES ("108", "Thank U, Next", "8", "10000000.0", "1.0");
INSERT INTO "song" VALUES ("109", "Uptown Funk", "9", "20000000.0", "1.0");
INSERT INTO "song" VALUES ("110", "Bad Romance", "10", "12000000.0", "2.0");
INSERT INTO "song" VALUES ("111", "Viva La Vida", "11", "6000000.0", "1.0");
INSERT INTO "song" VALUES ("112", "Don't Start Now", "12", "5000000.0", "2.0");
INSERT INTO "song" VALUES ("113", "Blinding Lights", "13", "20000000.0", "1.0");
INSERT INTO "song" VALUES ("114", "Bad Guy", "14", "10000000.0", "1.0");
INSERT INTO "song" VALUES ("115", "Stitches", "15", "5000000.0", "4.0");
INSERT INTO "song" VALUES ("116", "Someone Like You", "1", "17000000.0", "1.0");
INSERT INTO "song" VALUES ("117", "Thinking Out Loud", "2", "18000000.0", "2.0");
INSERT INTO "song" VALUES ("118", "Shake It Off", "3", "10000000.0", "1.0");
INSERT INTO "song" VALUES ("119", "Love Yourself", "4", "10000000.0", "1.0");
INSERT INTO "song" VALUES ("120", "Halo", "5", "5000000.0", "5.0");
INSERT INTO "song" VALUES ("121", "Work", "6", "7000000.0", "1.0");
INSERT INTO "song" VALUES ("122", "God's Plan", "7", "15000000.0", "1.0");
INSERT INTO "song" VALUES ("123", "7 Rings", "8", "10000000.0", "1.0");
INSERT INTO "song" VALUES ("124", "Just the Way You Are", "9", "12000000.0", "1.0");
INSERT INTO "song" VALUES ("125", "Poker Face", "10", "14000000.0", "1.0");
INSERT INTO "song" VALUES ("126", "Fix You", "11", "4000000.0", "4.0");
INSERT INTO "song" VALUES ("127", "New Rules", "12", "6000000.0", "6.0");
INSERT INTO "song" VALUES ("128", "Starboy", "13", "10000000.0", "1.0");
INSERT INTO "song" VALUES ("129", "Ocean Eyes", "14", "5000000.0", "8.0");
INSERT INTO "song" VALUES ("130", "Senorita", "15", "10000000.0", "1.0");
INSERT INTO "song" VALUES ("131", "Rolling in the Deep", "1", "20000000.0", "1.0");
INSERT INTO "song" VALUES ("132", "Perfect", "2", "15000000.0", "1.0");
INSERT INTO "song" VALUES ("133", "All Too Well", "3", "500000.0", "1.0");
INSERT INTO "song" VALUES ("134", "Despacito Remix", "4", "13000000.0", "1.0");
INSERT INTO "song" VALUES ("135", "Crazy in Love", "5", "4000000.0", "1.0");
INSERT INTO "song" VALUES ("136", "Diamonds", "6", "7000000.0", "1.0");
INSERT INTO "song" VALUES ("137", "One Dance", "7", "10000000.0", "1.0");
INSERT INTO "song" VALUES ("138", "Side to Side", "8", "8000000.0", "4.0");
INSERT INTO "song" VALUES ("139", "Grenade", "9", "10000000.0", "1.0");
INSERT INTO "song" VALUES ("140", "Shallow", "10", "10000000.0", "1.0");
INSERT INTO "song" VALUES ("141", "A Sky Full of Stars", "11", "3000000.0", "10.0");
INSERT INTO "song" VALUES ("142", "Levitating", "12", "8000000.0", "2.0");
INSERT INTO "song" VALUES ("143", "The Hills", "13", "8000000.0", "1.0");
INSERT INTO "song" VALUES ("144", "When the Party's Over", "14", "300000.0", "21.0");
INSERT INTO "song" VALUES ("145", "Treat You Better", "15", "4000000.0", "6.0");
INSERT INTO "song" VALUES ("146", "Set Fire to the Rain", "1", "9000000.0", "1.0");
INSERT INTO "song" VALUES ("147", "Castle on the Hill", "2", "7000000.0", "6.0");
INSERT INTO "song" VALUES ("148", "You Belong With Me", "3", "5000000.0", "2.0");
INSERT INTO "song" VALUES ("149", "What Do You Mean?", "4", "8000000.0", "1.0");
INSERT INTO "song" VALUES ("150", "Formation", "5", "3000000.0", "10.0");
INSERT INTO "song" VALUES ("151", "We Found Love", "6", "9000000.0", "1.0");
INSERT INTO "song" VALUES ("152", "In My Feelings", "7", "10000000.0", "1.0");
INSERT INTO "song" VALUES ("153", "No Tears Left to Cry", "8", "7000000.0", "2.0");
INSERT INTO "song" VALUES ("154", "24K Magic", "9", "8000000.0", "4.0");
INSERT INTO "song" VALUES ("155", "Born This Way", "10", "8000000.0", "1.0");
INSERT INTO "song" VALUES ("156", "Yellow", "11", "2000000.0", "48.0");
INSERT INTO "song" VALUES ("157", "Physical", "12", "4000000.0", "3.0");
INSERT INTO "song" VALUES ("158", "Can't Feel My Face", "13", "7000000.0", "1.0");
INSERT INTO "song" VALUES ("159", "Everything I Wanted", "14", "6000000.0", "8.0");
INSERT INTO "song" VALUES ("160", "Mercy", "15", "3000000.0", "15.0");
INSERT INTO "song" VALUES ("161", "Chasing Pavements", "1", "200000.0", "21.0");
INSERT INTO "song" VALUES ("162", "Photograph", "2", "250000.0", "10.0");
INSERT INTO "song" VALUES ("163", "Cardigan", "3", "200000.0", "1.0");
INSERT INTO "song" VALUES ("164", "Yummy", "4", "290000.0", "2.0");
INSERT INTO "song" VALUES ("165", "Drunk in Love", "5", "280000.0", "2.0");
INSERT INTO "song" VALUES ("166", "Needed Me", "6", "270000.0", "7.0");
INSERT INTO "song" VALUES ("167", "Toosie Slide", "7", "260000.0", "1.0");
INSERT INTO "song" VALUES ("168", "Positions", "8", "250000.0", "1.0");
INSERT INTO "song" VALUES ("169", "That's What I Like", "9", "240000.0", "1.0");
INSERT INTO "song" VALUES ("170", "Rain On Me", "10", "230000.0", "1.0");
INSERT INTO "song" VALUES ("171", "Something Just Like This", "11", "220000.0", "3.0");
INSERT INTO "song" VALUES ("172", "IDGAF", "12", "210000.0", "49.0");
INSERT INTO "song" VALUES ("173", "Call Out My Name", "13", "200000.0", "24.0");
INSERT INTO "song" VALUES ("174", "Lovely", "14", "190000.0", "64.0");
INSERT INTO "song" VALUES ("175", "There's Nothing Holdin' Me Back", "15", "180000.0", "6.0");