/
albums_seeder.sql
41 lines (35 loc) · 3.4 KB
/
albums_seeder.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
USE codeup;
TRUNCATE albums;
INSERT INTO albums (artist, album, genre, release_date, sales_in_millions)
values
('Michael Jackson' , 'Thriller' , 'Pop, Rock, R&B' , 1982, 46.0),
('AC/DC' , 'Back in Black' , 'Heavy Rock' , 1980, 26.1),
('Pink Floyd' , 'Dark Side of the Moon' , 'Progressive Rock' , 1973, 24.2),
('Whitney Houston' , 'The Bodyguard' , 'R&B, Soul, Pop, Soundtrack' , 1992, 27.4),
('Meat Loaf' , 'Bat Out of Hell' , 'Progressive Rock, Hard Rock', 1977, 20.6),
('Eagles' ,'Their Greatest Hits' , 'Rock, Soft rock, Folk rock' , 1976, 32.2),
('Bee Gees' ,'Saturday Night Fever' , 'Disco' , 1977, 20.6),
('Fleetwood Mac' , 'Rumors' , 'Soft Rock' , 1977, 27.9),
('Shania Twain' , 'Come On Over' , 'Country, Pop' , 1997, 29.6),
('Led Zeppelin' , 'Led Zeppelin IV' , 'Hard Rock, Heavy Metal' , 1971, 29.0),
('Adele' , '21' , 'Pop' , 2011, 25.3),
('Michael Jackson' , 'Bad' , 'Pop' , 1987, 20.3),
('Alanis Morissette','Jagged Little Pill' , 'Alternative Rock' , 1995, 24.8),
('Celine Dion' , 'Falling into You' , 'Pop, Soft rock' , 1996, 20.2),
('The Beatles' , 'Sgt. Pepper''s Lonely Hearts Club Band', 'Rock' , 1967, 13.1),
('Eagles' , 'Hotel California' , 'Rock, Soft rock, Folk rock' , 1976, 21.5),
('Mariah Carey' , 'Music Box' , 'R&B' , 1993, 19.0),
('Michael Jackson' , 'Dangerous' , 'Rock, Funk, Pop' , 1991, 17.60),
('Various Artists' , 'Dirty Dancing' , 'Pop, Rock, R&B' , 1987, 17.90),
('Celine Dion' , 'Let\'s Talk About Love' , 'Pop, Soft Rock' , 1997, 19.30),
('The Beatles' , '1' , 'Rock' , 2000, 21.60),
('The Beatles' , 'Abbey Road' , 'Rock' , 1969, 14.40),
('Bruce Springsteen', 'Born in the U.S.A.' , 'Rock' , 1984, 19.60),
('Dire Straits' , 'Brothers in Arms' , 'Rock' , 1985, 17.70),
('James Horner' , 'Titanic: Music from the Motion Picture', 'Soundtrack' , 1997, 18.10),
('Madonna' , 'The Immaculate Collection' , 'Pop, Dance' , 1990, 19.40),
('Metallica' , 'Metallica' , 'Thrash Metal, Heavy Metal' , 1991, 19.90),
('Nirvana' , 'Nevermind' , 'Grunge, Alternative Rock' , 1991, 16.70),
('Pink Floyd' , 'The Wall' , 'Progressive Rock' , 1979, 17.60),
('Santana' , 'Supernatural' , 'Rock' , 1999, 20.50),
('Guns N\' Roses' , 'Appetite for Destruction' , 'Heavy Metal, Hard Rock' , 1987, 21.30);