pamela's favorite songs SQL

songs.sql

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);