seeder.sql

USE codeup_test_db;
TRUNCATE albums;
INSERT INTO albums (artist, name, release_date, genre, sales)
    VALUES 
    ("Michael Jackson", "Thriller", 1982, "Pop, rock, R&B", 43.3),
    ("AC/DC", "Back in Black", 1980, "Hard rock", 25.9),
    ("Pink Floyd", "The Dark Side of the Moon", 1973, "Progressive rock", 22.7),
    ("Whitney Houston / Various artists", "The Bodyguard", 1992, "Soundtrack/R&B, soul, pop", 27.4),
    ("Meat Loaf", "Bat Out of Hell", 1977, "Hard rock, progressive rock", 20.6),
    ("Eagles", "Their Greatest Hits (1971–1975)", 1976, "Rock, soft rock, folk rock", 32.2),
    ("Bee Gees / Various artists", "Saturday Night Fever", 1977, "Disco", 19),
    ("Fleetwood Mac", "Rumours", 1977, "Soft rock", 27.9),
    ("Shania Twain", "Come On Over", 1997, "Country, pop", 29.6),
    ("Led Zeppelin", "Led Zeppelin IV", 1971, "Hard rock, heavy metal", 29.0),
    ("Spice Girls", "Spice", 1996, "Pop", 28),
    ("Alanis Morissette", "Jagged Little Pill", 1995, "Alternative rock", 24.8),
    ("Celine Dion", "Falling into You", 1996, "Pop / Soft rock", 20.2),
    ("The Beatles", "Sgt. Pepper's Lonely Hearts Club Band", 1967, "Rock", 13.1),
    ("Eagles", "Hotel California", 1976, "Rock, soft rock, folk rock", 21.5),
    ("Mariah Carey", "Music Box", 1993, "Pop / R&B / Rock", 19.5),
    ("Various artists", "Dirty Dancing", 1987, "Pop, rock, R&B", 17.9),
    ("Celine Dion", "Let's Talk About Love", 1997, "Pop / Soft rock", 19.3),
    ("The Beatles", 1, 2000, "Rock", 21.6),
    ("Adele", 21, 2011, "Pop, soul", 21.3),
    ("The Beatles", "Abbey Road", 1969, "Rock", 14.4),
    ("Bruce Springsteen", "Born in the U.S.A.", 1984, "Rock", 19.6),
    ("Dire Straits", "Brothers in Arms", 1985, "Rock", 18.6),
    ("Whitney Houston", "Whitney Houston", 1985, "Pop, R&B", 17.2),
    ("James Horner", "Titanic: Music from the Motion Picture", 1997, "Soundtrack", 18.1),
    ("Madonna", "The Immaculate Collection", 1990, "Pop / Dance", 19.4),
    ("Metallica", "Metallica", 1991, "Thrash metal / heavy metal", 19.9),
    ("Michael Jackson", "Bad", 1987, "Pop, funk, rock", 18.4),
    ("Michael Jackson", "Dangerous", 1991, "Rock / Funk / Pop", 16.3),
    ("Nirvana", "Nevermind", 1991, "Grunge, alternative rock", 16.7),
    ("Pink Floyd", "The Wall", 1979, "Progressive rock", 17.6),
    ("Santana", "Supernatural", 1999, "Rock", 20.5),
    ("Guns N' Roses", "Appetite for Destruction", 1987, "Heavy metal / hard rock", 21.3),
    ("ABBA", "Gold: Greatest Hits", 1992, "Pop", 30),
    ("Bon Jovi", "Slippery When Wet", 1986, "Hard rock", 24),
    ("Various artists", "Grease: The Original Soundtrack from the Motion Picture", 1978, "Soundtrack", 42),
    ("Britney Spears", "...Baby One More Time", 1999, "Pop", 26),
    ("Linkin Park", "Hybrid Theory", 2000, "Nu metal, rap metal, alternative metal", 20),
    ("Bob Marley & The Wailers", "Legend: The Best of Bob Marley & The Wailers", 1984, "Reggae", 34),
    ("Carole King", "Tapestry", 1971, "Pop", 20),
    ("Madonna", "Like a Virgin", 1984, "Pop, dance", 22),
    ("Madonna", "True Blue", 1986, "Pop", 24),
    ("Mariah Carey", "Daydream", 1995, "Pop, R&B", 22),
    ("Norah Jones", "Come Away with Me", 2002, "Jazz", 26),
    ("Queen", "Greatest Hits", 1981, "Rock", 30),
    ("Simon & Garfunkel", "Bridge over Troubled Water", 1970, "Folk rock", 24),
    ("U2", "The Joshua Tree", 1987, "Rock", 30),
    ("Backstreet Boys", "Backstreet's Back / Backstreet Boys", 1997, "Pop", 24),
    ("Backstreet Boys", "Millennium", 1999, "Pop", 26),
    ("Ace of Base", "Happy Nation/The Sign", 1993, "Pop", 22),
    ("TLC", "CrazySexyCool", 1994, "R&B, hip hop", 23),
    ("Cyndi Lauper", "She's So Unusual", 1983, "New wave, pop rock, synthpop", 22),
    ("Oasis", "(What's the Story) Morning Glory?", 1995, "Britpop, rock", 18),
    ("Bon Jovi", "Cross Road", 1994, "Hard rock", 22),
    ("Eminem", "The Marshall Mathers LP", 2000, "Rap, hip-hop", 24),
    ("Dido", "No Angel", 1999, "Pop", 21),
    ("Celine Dion", "The Colour of My Love", 1993, "Pop / Soft rock", 20),
    ("Avril Lavigne", "Let Go", 2002, "Pop rock, alternative rock", 18),
    ("Boston", "Boston", 1976, "Hard rock", 22),
    ("Britney Spears", "Oops!... I Did It Again", 2000, "Pop", 24),
    ("Def Leppard", "Hysteria", 1987, "Pop, Hard rock", 20),
    ("Fei Xiang", "A Voice on the Ocean", 1986, "Mandopop", 20),
    ("Eric Clapton", "Unplugged", 1992, "Acoustic blues, folk rock", 26),
    ("Lionel Richie", "Can't Slow Down", 1983, "Pop, R&B, soul", 22),
    ("Madonna", "Ray of Light", 1998, "Pop, Dance, Electronica", 20),
    ("Michael Jackson", "HIStory: Past, Present and Future, Book I", 1995, "Pop, rock, R&B", 22),
    ("Michael Jackson", "Off the Wall", 1979, "Soul, disco, R&B", 22),
    ("Phil Collins", "No Jacket Required", 1985, "Pop, Rock", 24),
    ("Prince & The Revolution", "Purple Rain", 1984, "Pop, rock, R&B", 22),
    ("Shania Twain", "The Woman in Me", 1995, "Country, pop", 20),
    ("Supertramp", "Breakfast in America", 1979, "Progressive rock, art rock", 20),
    ("Toni Braxton", "Secrets", 1996, "R&B, Pop", 20),
    ("Usher", "Confessions", 2004, "R&B", 20),
    ("Green Day", "Dookie", 1994, "Pop-punk, punk rock, alternative rock", 20),
    ("Shakira", "Laundry Service", 2001, "Pop, Rock", 20)
;