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

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





INSERT INTO "singer" VALUES ("1", "Frank Sinatra", "1915", "USA");
INSERT INTO "singer" VALUES ("2", "Elvis Presley", "1935", "USA");
INSERT INTO "singer" VALUES ("3", "Aretha Franklin", "1942", "USA");
INSERT INTO "singer" VALUES ("4", "Bob Dylan", "1941", "USA");
INSERT INTO "singer" VALUES ("5", "Paul McCartney", "1942", "UK");
INSERT INTO "singer" VALUES ("6", "Mick Jagger", "1943", "UK");
INSERT INTO "singer" VALUES ("7", "Stevie Wonder", "1950", "USA");
INSERT INTO "singer" VALUES ("8", "Elton John", "1947", "UK");
INSERT INTO "singer" VALUES ("9", "Madonna", "1958", "USA");
INSERT INTO "singer" VALUES ("10", "Michael Jackson", "1958", "USA");
INSERT INTO "singer" VALUES ("11", "Prince", "1958", "USA");
INSERT INTO "singer" VALUES ("12", "Whitney Houston", "1963", "USA");
INSERT INTO "singer" VALUES ("13", "Bono", "1960", "Ireland");
INSERT INTO "singer" VALUES ("14", "Sting", "1951", "UK");
INSERT INTO "singer" VALUES ("15", "Adele", "1988", "UK");
INSERT INTO "singer" VALUES ("16", "Ed Sheeran", "1991", "UK");
INSERT INTO "singer" VALUES ("17", "Celine Dion", "1968", "Canada");
INSERT INTO "singer" VALUES ("18", "Leonard Cohen", "1934", "Canada");
INSERT INTO "singer" VALUES ("19", "Joni Mitchell", "1943", "Canada");
INSERT INTO "singer" VALUES ("20", "Julio Iglesias", "1943", "Spain");
INSERT INTO "singer" VALUES ("21", "Placido Domingo", "1941", "Spain");
INSERT INTO "singer" VALUES ("22", "Shakira", "1977", "Colombia");
INSERT INTO "singer" VALUES ("23", "Juanes", "1972", "Colombia");
INSERT INTO "singer" VALUES ("24", "Andrea Bocelli", "1958", "Italy");
INSERT INTO "singer" VALUES ("25", "Luciano Pavarotti", "1935", "Italy");
INSERT INTO "singer" VALUES ("26", "Laura Pausini", "1974", "Italy");
INSERT INTO "singer" VALUES ("27", "Charles Aznavour", "1924", "France");
INSERT INTO "singer" VALUES ("28", "Edith Piaf", "1915", "France");
INSERT INTO "singer" VALUES ("29", "Johnny Hallyday", "1943", "France");
INSERT INTO "singer" VALUES ("30", "Stromae", "1985", "Belgium");
INSERT INTO "song" VALUES ("1", "My Way", "10000000.0");
INSERT INTO "song" VALUES ("2", "Hound Dog", "12000000.0");
INSERT INTO "song" VALUES ("3", "Respect", "8000000.0");
INSERT INTO "song" VALUES ("4", "Like a Rolling Stone", "7000000.0");
INSERT INTO "song" VALUES ("6", "Satisfaction", "11000000.0");
INSERT INTO "song" VALUES ("7", "Superstition", "9000000.0");
INSERT INTO "song" VALUES ("8", "Rocket Man", "9500000.0");
INSERT INTO "song" VALUES ("9", "Like a Prayer", "13000000.0");
INSERT INTO "song" VALUES ("10", "Billie Jean", "20000000.0");
INSERT INTO "song" VALUES ("11", "Purple Rain", "18000000.0");
INSERT INTO "song" VALUES ("12", "I Will Always Love You", "16000000.0");
INSERT INTO "song" VALUES ("13", "With or Without You", "7500000.0");
INSERT INTO "song" VALUES ("14", "Every Breath You Take", "8500000.0");
INSERT INTO "song" VALUES ("15", "Someone Like You", "14000000.0");
INSERT INTO "song" VALUES ("16", "Shape of You", "25000000.0");
INSERT INTO "song" VALUES ("17", "My Heart Will Go On", "19000000.0");
INSERT INTO "song" VALUES ("18", "Hallelujah", "6000000.0");
INSERT INTO "song" VALUES ("19", "Big Yellow Taxi", "5500000.0");
INSERT INTO "song" VALUES ("20", "To All the Girls I've Loved Before", "4000000.0");
INSERT INTO "song" VALUES ("21", "Nessun Dorma", "3000000.0");
INSERT INTO "song" VALUES ("22", "Waka Waka", "10000000.0");
INSERT INTO "song" VALUES ("23", "A Dios le Pido", "5000000.0");
INSERT INTO "song" VALUES ("24", "Con te partirò", "12000000.0");
INSERT INTO "song" VALUES ("25", "O Sole Mio", "2500000.0");
INSERT INTO "song" VALUES ("26", "La Solitudine", "6000000.0");
INSERT INTO "song" VALUES ("27", "La Bohème", "3500000.0");
INSERT INTO "song" VALUES ("28", "La Vie en rose", "4500000.0");
INSERT INTO "song" VALUES ("29", "Que je t'aime", "7000000.0");
INSERT INTO "song" VALUES ("30", "Alors on danse", "9000000.0");