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

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





INSERT INTO "singer" VALUES ("1", "Adele", "1988.0");
INSERT INTO "singer" VALUES ("2", "Ed Sheeran", "1991.0");
INSERT INTO "singer" VALUES ("3", "Taylor Swift", "1989.0");
INSERT INTO "singer" VALUES ("4", "Beyoncé", "1981.0");
INSERT INTO "singer" VALUES ("5", "Drake", "1986.0");
INSERT INTO "singer" VALUES ("6", "Rihanna", "1988.0");
INSERT INTO "singer" VALUES ("7", "Justin Bieber", "1994.0");
INSERT INTO "singer" VALUES ("8", "Ariana Grande", "1993.0");
INSERT INTO "singer" VALUES ("9", "Bruno Mars", "1985.0");
INSERT INTO "singer" VALUES ("10", "Lady Gaga", "1986.0");
INSERT INTO "singer" VALUES ("11", "Sia", "1975.0");
INSERT INTO "singer" VALUES ("12", "The Weeknd", "1990.0");
INSERT INTO "singer" VALUES ("13", "Dua Lipa", "1995.0");
INSERT INTO "singer" VALUES ("14", "Billie Eilish", "2001.0");
INSERT INTO "singer" VALUES ("15", "Post Malone", "1995.0");
INSERT INTO "singer" VALUES ("16", "Katy Perry", "1984.0");
INSERT INTO "singer" VALUES ("17", "Sam Smith", "1992.0");
INSERT INTO "singer" VALUES ("18", "Shawn Mendes", "1998.0");
INSERT INTO "singer" VALUES ("19", "Camila Cabello", "1997.0");
INSERT INTO "singer" VALUES ("20", "Halsey", "1994.0");
INSERT INTO "singer" VALUES ("21", "John Legend", "1978.0");
INSERT INTO "singer" VALUES ("22", "Alicia Keys", "1981.0");
INSERT INTO "singer" VALUES ("23", "Coldplay", "1996.0");
INSERT INTO "singer" VALUES ("24", "Maroon 5", "1994.0");
INSERT INTO "singer" VALUES ("25", "Imagine Dragons", "2008.0");
INSERT INTO "singer" VALUES ("26", "Queen", "1970.0");
INSERT INTO "singer" VALUES ("27", "Michael Jackson", "1958.0");
INSERT INTO "singer" VALUES ("28", "Whitney Houston", "1963.0");
INSERT INTO "singer" VALUES ("29", "Elvis Presley", "1935.0");
INSERT INTO "singer" VALUES ("30", "Frank Sinatra", "1915.0");
INSERT INTO "singer" VALUES ("31", "Bob Dylan", "1941.0");
INSERT INTO "singer" VALUES ("32", "Aretha Franklin", "1942.0");
INSERT INTO "singer" VALUES ("33", "Stevie Wonder", "1950.0");
INSERT INTO "singer" VALUES ("34", "Madonna", "1958.0");
INSERT INTO "singer" VALUES ("35", "Prince", "1958.0");
INSERT INTO "singer" VALUES ("36", "Elton John", "1947.0");
INSERT INTO "singer" VALUES ("37", "Paul McCartney", "1942.0");
INSERT INTO "singer" VALUES ("38", "Freddie Mercury", "1946.0");
INSERT INTO "singer" VALUES ("39", "David Bowie", "1947.0");
INSERT INTO "singer" VALUES ("40", "George Michael", "1963.0");
INSERT INTO "singer" VALUES ("41", "Amy Winehouse", "1983.0");
INSERT INTO "singer" VALUES ("42", "Kurt Cobain", "1967.0");
INSERT INTO "singer" VALUES ("43", "Jimi Hendrix", "1942.0");
INSERT INTO "singer" VALUES ("44", "Janis Joplin", "1943.0");
INSERT INTO "singer" VALUES ("45", "Jim Morrison", "1943.0");
INSERT INTO "singer" VALUES ("46", "Johnny Cash", "1932.0");
INSERT INTO "singer" VALUES ("47", "Dolly Parton", "1946.0");
INSERT INTO "singer" VALUES ("48", "Willie Nelson", "1933.0");
INSERT INTO "singer" VALUES ("49", "Merle Haggard", "1937.0");
INSERT INTO "singer" VALUES ("50", "George Jones", "1931.0");
INSERT INTO "singer" VALUES ("51", "Alan Jackson", "1958.0");
INSERT INTO "singer" VALUES ("52", "Garth Brooks", "1962.0");
INSERT INTO "singer" VALUES ("53", "Shania Twain", "1965.0");
INSERT INTO "singer" VALUES ("54", "Carrie Underwood", "1983.0");
INSERT INTO "singer" VALUES ("55", "Luke Bryan", "1976.0");
INSERT INTO "singer" VALUES ("56", "Blake Shelton", "1976.0");
INSERT INTO "singer" VALUES ("57", "Miranda Lambert", "1983.0");
INSERT INTO "singer" VALUES ("58", "Chris Stapleton", "1978.0");
INSERT INTO "singer" VALUES ("59", "Kacey Musgraves", "1988.0");
INSERT INTO "singer" VALUES ("60", "Maren Morris", "1990.0");
INSERT INTO "singer" VALUES ("61", "Thomas Rhett", "1990.0");
INSERT INTO "singer" VALUES ("62", "Florida Georgia Line", "2010.0");
INSERT INTO "singer" VALUES ("63", "Old Dominion", "2007.0");
INSERT INTO "singer" VALUES ("64", "Dan + Shay", "2012.0");
INSERT INTO "singer" VALUES ("65", "Brothers Osborne", "2012.0");
INSERT INTO "singer" VALUES ("66", "Little Big Town", "1998.0");
INSERT INTO "singer" VALUES ("67", "Zac Brown Band", "2002.0");
INSERT INTO "singer" VALUES ("68", "Lady A", "2006.0");
INSERT INTO "singer" VALUES ("69", "Rascal Flatts", "1999.0");
INSERT INTO "singer" VALUES ("70", "Sugarland", "2002.0");
INSERT INTO "singer" VALUES ("71", "Keith Urban", "1967.0");
INSERT INTO "singer" VALUES ("72", "Tim McGraw", "1967.0");
INSERT INTO "singer" VALUES ("73", "Faith Hill", "1967.0");
INSERT INTO "singer" VALUES ("74", "Reba McEntire", "1955.0");
INSERT INTO "singer" VALUES ("75", "Brooks & Dunn", "1990.0");
INSERT INTO "singer" VALUES ("76", "Toby Keith", "1961.0");
INSERT INTO "singer" VALUES ("77", "Kenny Chesney", "1968.0");
INSERT INTO "singer" VALUES ("78", "Brad Paisley", "1972.0");
INSERT INTO "singer" VALUES ("79", "Dierks Bentley", "1975.0");
INSERT INTO "singer" VALUES ("80", "Jason Aldean", "1977.0");
INSERT INTO "singer" VALUES ("81", "Eric Church", "1977.0");
INSERT INTO "singer" VALUES ("82", "Kenny Rogers", "1938.0");
INSERT INTO "singer" VALUES ("83", "Glen Campbell", "1936.0");
INSERT INTO "singer" VALUES ("84", "Charley Pride", "1934.0");
INSERT INTO "singer" VALUES ("85", "Loretta Lynn", "1932.0");
INSERT INTO "singer" VALUES ("86", "Patsy Cline", "1932.0");
INSERT INTO "singer" VALUES ("87", "Hank Williams", "1923.0");
INSERT INTO "singer" VALUES ("88", "Waylon Jennings", "1937.0");
INSERT INTO "singer" VALUES ("89", "Kris Kristofferson", "1936.0");
INSERT INTO "singer" VALUES ("90", "Jerry Lee Lewis", "1935.0");
INSERT INTO "singer" VALUES ("91", "Chuck Berry", "1926.0");
INSERT INTO "singer" VALUES ("92", "Little Richard", "1932.0");
INSERT INTO "singer" VALUES ("93", "Fats Domino", "1928.0");
INSERT INTO "singer" VALUES ("94", "Buddy Holly", "1936.0");
INSERT INTO "singer" VALUES ("95", "Roy Orbison", "1936.0");
INSERT INTO "singer" VALUES ("96", "Sam Cooke", "1931.0");
INSERT INTO "singer" VALUES ("97", "Otis Redding", "1941.0");
INSERT INTO "singer" VALUES ("98", "Marvin Gaye", "1939.0");
INSERT INTO "singer" VALUES ("99", "Al Green", "1946.0");
INSERT INTO "singer" VALUES ("100", "James Brown", "1933.0");
INSERT INTO "singer" VALUES ("101", "Aretha Franklin", "1942.0");
INSERT INTO "singer" VALUES ("102", "Etta James", "1938.0");
INSERT INTO "singer" VALUES ("103", "Nina Simone", "1933.0");
INSERT INTO "singer" VALUES ("104", "Billie Holiday", "1915.0");
INSERT INTO "singer" VALUES ("105", "Ella Fitzgerald", "1917.0");
INSERT INTO "singer" VALUES ("106", "Louis Armstrong", "1901.0");
INSERT INTO "singer" VALUES ("107", "Miles Davis", "1926.0");
INSERT INTO "singer" VALUES ("108", "John Coltrane", "1926.0");
INSERT INTO "singer" VALUES ("109", "Duke Ellington", "1899.0");
INSERT INTO "singer" VALUES ("110", "Frank Zappa", "1940.0");
INSERT INTO "singer" VALUES ("111", "Captain Beefheart", "1941.0");
INSERT INTO "singer" VALUES ("112", "Tom Waits", "1949.0");
INSERT INTO "singer" VALUES ("113", "Leonard Cohen", "1934.0");
INSERT INTO "singer" VALUES ("114", "Joni Mitchell", "1943.0");
INSERT INTO "singer" VALUES ("115", "Carole King", "1942.0");
INSERT INTO "singer" VALUES ("116", "James Taylor", "1948.0");
INSERT INTO "singer" VALUES ("117", "Cat Stevens", "1948.0");
INSERT INTO "singer" VALUES ("118", "Neil Young", "1945.0");
INSERT INTO "singer" VALUES ("119", "Van Morrison", "1945.0");
INSERT INTO "singer" VALUES ("120", "Bob Marley", "1945.0");
INSERT INTO "singer" VALUES ("121", "Peter Tosh", "1944.0");
INSERT INTO "singer" VALUES ("122", "Jimmy Cliff", "1948.0");
INSERT INTO "singer" VALUES ("123", "Toots Hibbert", "1942.0");
INSERT INTO "singer" VALUES ("124", "Burning Spear", "1945.0");
INSERT INTO "singer" VALUES ("125", "Dennis Brown", "1957.0");
INSERT INTO "singer" VALUES ("126", "Gregory Isaacs", "1951.0");
INSERT INTO "singer" VALUES ("127", "Buju Banton", "1973.0");
INSERT INTO "singer" VALUES ("128", "Shabba Ranks", "1966.0");
INSERT INTO "singer" VALUES ("129", "Sean Paul", "1973.0");
INSERT INTO "singer" VALUES ("130", "Damian Marley", "1978.0");
INSERT INTO "singer" VALUES ("131", "Ziggy Marley", "1968.0");
INSERT INTO "singer" VALUES ("132", "Stephen Marley", "1972.0");
INSERT INTO "singer" VALUES ("133", "Ky-Mani Marley", "1976.0");
INSERT INTO "singer" VALUES ("134", "Julian Marley", "1975.0");
INSERT INTO "singer" VALUES ("135", "Protoje", "1981.0");
INSERT INTO "singer" VALUES ("136", "Chronixx", "1992.0");
INSERT INTO "singer" VALUES ("137", "Koffee", "2000.0");
INSERT INTO "singer" VALUES ("138", "Popcaan", "1988.0");
INSERT INTO "singer" VALUES ("139", "Vybz Kartel", "1976.0");
INSERT INTO "singer" VALUES ("140", "Mavado", "1980.0");
INSERT INTO "singer" VALUES ("141", "Busy Signal", "1982.0");
INSERT INTO "singer" VALUES ("142", "Aidonia", "1981.0");
INSERT INTO "singer" VALUES ("143", "Alkaline", "1993.0");
INSERT INTO "singer" VALUES ("144", "Masicka", "1993.0");
INSERT INTO "singer" VALUES ("145", "Skillibeng", "1996.0");
INSERT INTO "singer" VALUES ("146", "Jah Cure", "1978.0");
INSERT INTO "singer" VALUES ("147", "Capleton", "1967.0");
INSERT INTO "singer" VALUES ("148", "Sizzla", "1976.0");
INSERT INTO "singer" VALUES ("149", "Beres Hammond", "1955.0");
INSERT INTO "singer" VALUES ("150", "Tarrus Riley", "1979.0");
INSERT INTO "singer" VALUES ("151", "Romain Virgo", "1990.0");
INSERT INTO "singer" VALUES ("152", "Christopher Martin", "1987.0");
INSERT INTO "singer" VALUES ("153", "Busy Signal", "1982.0");
INSERT INTO "singer" VALUES ("154", "Dexta Daps", "1986.0");
INSERT INTO "singer" VALUES ("155", "Shenseea", "1996.0");
INSERT INTO "singer" VALUES ("156", "Spice", "1982.0");
INSERT INTO "singer" VALUES ("157", "Jada Kingdom", "1998.0");
INSERT INTO "singer" VALUES ("158", "Lila Iké", "1994.0");
INSERT INTO "singer" VALUES ("159", "Sevana", "1992.0");
INSERT INTO "singer" VALUES ("160", "Jesse Royal", "1989.0");
INSERT INTO "singer" VALUES ("161", "Kabaka Pyramid", "1986.0");
INSERT INTO "singer" VALUES ("162", "Agent Sasco", "1982.0");
INSERT INTO "singer" VALUES ("163", "Mr. Vegas", "1974.0");
INSERT INTO "singer" VALUES ("164", "Elephant Man", "1975.0");
INSERT INTO "singer" VALUES ("165", "Beenie Man", "1973.0");
INSERT INTO "singer" VALUES ("166", "Bounty Killer", "1972.0");
INSERT INTO "singer" VALUES ("167", "Super Cat", "1963.0");
INSERT INTO "singer" VALUES ("168", "Shinehead", "1962.0");
INSERT INTO "singer" VALUES ("169", "Sister Nancy", "1962.0");
INSERT INTO "singer" VALUES ("170", "Yellowman", "1956.0");
INSERT INTO "singer" VALUES ("171", "Eek-A-Mouse", "1957.0");
INSERT INTO "singer" VALUES ("172", "Barrington Levy", "1964.0");
INSERT INTO "singer" VALUES ("173", "Frankie Paul", "1965.0");
INSERT INTO "singer" VALUES ("174", "Wayne Wonder", "1972.0");
INSERT INTO "singer" VALUES ("175", "Sanchez", "1964.0");
INSERT INTO "singer" VALUES ("176", "Freddie McGregor", "1956.0");
INSERT INTO "singer" VALUES ("177", "Ken Boothe", "1948.0");
INSERT INTO "singer" VALUES ("178", "John Holt", "1947.0");
INSERT INTO "singer" VALUES ("179", "Alton Ellis", "1938.0");
INSERT INTO "singer" VALUES ("180", "Delroy Wilson", "1948.0");
INSERT INTO "singer" VALUES ("181", "Horace Andy", "1951.0");
INSERT INTO "singer" VALUES ("182", "Augustus Pablo", "1954.0");
INSERT INTO "singer" VALUES ("183", "Lee Scratch Perry", "1936.0");
INSERT INTO "singer" VALUES ("184", "King Tubby", "1941.0");
INSERT INTO "singer" VALUES ("185", "Scientist", "1960.0");
INSERT INTO "singer" VALUES ("186", "Mad Professor", "1955.0");
INSERT INTO "singer" VALUES ("187", "Adrian Sherwood", "1958.0");
INSERT INTO "singer" VALUES ("188", "Dub Syndicate", "1980.0");
INSERT INTO "singer" VALUES ("189", "African Head Charge", "1981.0");
INSERT INTO "singer" VALUES ("190", "Creation Rebel", "1978.0");
INSERT INTO "singer" VALUES ("191", "New Age Steppers", "1981.0");
INSERT INTO "singer" VALUES ("192", "Tackhead", "1985.0");
INSERT INTO "singer" VALUES ("193", "Mark Stewart + The Maffia", "1982.0");
INSERT INTO "singer" VALUES ("194", "The Pop Group", "1977.0");
INSERT INTO "singer" VALUES ("195", "Maximum Joy", "1979.0");
INSERT INTO "singer" VALUES ("196", "Rip Rig + Panic", "1981.0");
INSERT INTO "singer" VALUES ("197", "Pigbag", "1980.0");
INSERT INTO "singer" VALUES ("198", "The Slits", "1976.0");
INSERT INTO "singer" VALUES ("199", "ESG", "1978.0");
INSERT INTO "singer" VALUES ("200", "Liquid Liquid", "1980.0");
INSERT INTO "singer" VALUES ("201", "Arthur Russell", "1951.0");
INSERT INTO "singer" VALUES ("202", "Talking Heads", "1975.0");
INSERT INTO "singer" VALUES ("203", "The B-52's", "1976.0");
INSERT INTO "singer" VALUES ("204", "Devo", "1973.0");
INSERT INTO "singer" VALUES ("205", "Kraftwerk", "1970.0");
INSERT INTO "singer" VALUES ("206", "Can", "1968.0");
INSERT INTO "singer" VALUES ("207", "Neu!", "1971.0");
INSERT INTO "singer" VALUES ("208", "Faust", "1971.0");
INSERT INTO "singer" VALUES ("209", "Cluster", "1971.0");
INSERT INTO "singer" VALUES ("210", "Harmonia", "1973.0");
INSERT INTO "singer" VALUES ("211", "La Düsseldorf", "1976.0");
INSERT INTO "singer" VALUES ("212", "Ash Ra Tempel", "1970.0");
INSERT INTO "singer" VALUES ("213", "Tangerine Dream", "1967.0");
INSERT INTO "singer" VALUES ("214", "Klaus Schulze", "1947.0");
INSERT INTO "singer" VALUES ("215", "Manuel Göttsching", "1952.0");
INSERT INTO "singer" VALUES ("216", "Popol Vuh", "1970.0");
INSERT INTO "singer" VALUES ("217", "Amon Düül II", "1968.0");
INSERT INTO "singer" VALUES ("218", "Guru Guru", "1968.0");
INSERT INTO "singer" VALUES ("219", "Birth Control", "1968.0");
INSERT INTO "singer" VALUES ("220", "Eloy", "1969.0");
INSERT INTO "singer" VALUES ("221", "Jane", "1970.0");
INSERT INTO "singer" VALUES ("222", "Grobschnitt", "1970.0");
INSERT INTO "singer" VALUES ("223", "Novalis", "1971.0");
INSERT INTO "singer" VALUES ("224", "Anyone's Daughter", "1972.0");
INSERT INTO "singer" VALUES ("225", "Triumvirat", "1969.0");
INSERT INTO "singer" VALUES ("226", "Wallenstein", "1971.0");
INSERT INTO "singer" VALUES ("227", "Message", "1970.0");
INSERT INTO "singer" VALUES ("228", "Nektar", "1969.0");
INSERT INTO "singer" VALUES ("229", "Passport", "1971.0");
INSERT INTO "singer" VALUES ("230", "Kraan", "1970.0");
INSERT INTO "singer" VALUES ("231", "Embryo", "1969.0");
INSERT INTO "singer" VALUES ("232", "Between", "1970.0");
INSERT INTO "singer" VALUES ("233", "Deuter", "1970.0");
INSERT INTO "singer" VALUES ("234", "Gila", "1969.0");
INSERT INTO "singer" VALUES ("235", "Kollektiv", "1973.0");
INSERT INTO "singer" VALUES ("236", "Missus Beastly", "1974.0");
INSERT INTO "singer" VALUES ("237", "Out of Focus", "1969.0");
INSERT INTO "singer" VALUES ("238", "Xhol Caravan", "1967.0");
INSERT INTO "singer" VALUES ("239", "Zweistein", "1971.0");
INSERT INTO "singer" VALUES ("240", "Cosmic Jokers", "1974.0");
INSERT INTO "singer" VALUES ("241", "Ashra", "1976.0");
INSERT INTO "singer" VALUES ("242", "Michael Rother", "1977.0");
INSERT INTO "singer" VALUES ("243", "Dieter Moebius", "1978.0");
INSERT INTO "singer" VALUES ("244", "Hans-Joachim Roedelius", "1978.0");
INSERT INTO "singer" VALUES ("245", "Conrad Schnitzler", "1978.0");
INSERT INTO "singer" VALUES ("246", "Wolfgang Riechmann", "1978.0");
INSERT INTO "singer" VALUES ("247", "Klaus Dinger", "1978.0");
INSERT INTO "singer" VALUES ("248", "Jaki Liebezeit", "1978.0");
INSERT INTO "singer" VALUES ("249", "Holger Czukay", "1978.0");
INSERT INTO "singer" VALUES ("250", "Irmin Schmidt", "1978.0");
INSERT INTO "singer" VALUES ("251", "Damo Suzuki", "1978.0");
INSERT INTO "singer" VALUES ("252", "Malcolm Mooney", "1978.0");
INSERT INTO "singer" VALUES ("253", "Michael Karoli", "1978.0");
INSERT INTO "singer" VALUES ("254", "Rosko Gee", "1978.0");
INSERT INTO "singer" VALUES ("255", "Rebop Kwaku Baah", "1978.0");
INSERT INTO "singer" VALUES ("256", "Thurston Moore", "1958.0");
INSERT INTO "singer" VALUES ("257", "Kim Gordon", "1953.0");
INSERT INTO "singer" VALUES ("258", "Lee Ranaldo", "1956.0");
INSERT INTO "singer" VALUES ("259", "Steve Shelley", "1962.0");
INSERT INTO "singer" VALUES ("260", "Sonic Youth", "1981.0");
INSERT INTO "singer" VALUES ("261", "Dinosaur Jr.", "1984.0");
INSERT INTO "singer" VALUES ("262", "Pixies", "1986.0");
INSERT INTO "singer" VALUES ("263", "Nirvana", "1987.0");
INSERT INTO "singer" VALUES ("264", "Pearl Jam", "1990.0");
INSERT INTO "singer" VALUES ("265", "Soundgarden", "1984.0");
INSERT INTO "singer" VALUES ("266", "Alice in Chains", "1987.0");
INSERT INTO "singer" VALUES ("267", "Stone Temple Pilots", "1989.0");
INSERT INTO "singer" VALUES ("268", "Smashing Pumpkins", "1988.0");