Skip to content

Instantly share code, notes, and snippets.

@pamelafox

pamelafox/songs.sql

Created November 17, 2021 20:50
Show Gist options
  • Save pamelafox/0c92c5cc56504a45e2fd5aff0ec4c0f0 to your computer and use it in GitHub Desktop.
Save pamelafox/0c92c5cc56504a45e2fd5aff0ec4c0f0 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. pamelafox created this gist Nov 17, 2021.
    54 changes: 54 additions & 0 deletions songs.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,54 @@
    CREATE TABLE songs (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    artist TEXT,
    title TEXT,
    release_year INTEGER,
    views NUMERIC
    );

    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Lil Nas X", "Old Town Road", 2018, 851);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Lil Nas X", "Panini", 2019, 423);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Lil Nas X", "Montero (Call Me By Your Name)", 2021, 391);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Lil Nas X", "Sun Goes Down", 2021, 35);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Lil Nas X", "Industry Baby", 2021, 206);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Lil Nas X", "That's What I Want", 2021, 68);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Janelle Monáe", "Turntables", 2021, 2);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Janelle Monáe", "Make Me Feel", 2018, 31);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Janelle Monáe", "Tightrope", 2010, 28);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Janelle Monáe", "Dirty Computer", 2018, 3);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Ben Platt", "Grow as We Go", 2019, 23);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Ben Platt", "Rain", 2019, 4);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Ben Platt", "Older", 2019, 6);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Ben Platt", "Imagine", 2021, 2);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Ben Platt", "I Wanna Love You But I Don't", 2021, 1);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Robyn", "Dancing with Myself", 2010, 67);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Robyn", "Indestructible", 2011, 2);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Robyn", "Hang With Me", 2010, 7);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("Robyn", "Call Your Girlfriend", 2011, 29);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("P!nk", "Try", 2012, 487);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("P!nk", "All I Know So Far", 2021, 18);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("P!nk", "What About Us", 2017, 320);
    INSERT INTO songs (artist, title, release_year, views)
    VALUES ("P!nk", "Just Like A Pill", 2009, 137);