Skip to content
Snippets Groups Projects
dummy_data.sql 951 B
Newer Older
Angela Pham's avatar
Angela Pham committed
INSERT INTO artist (id, first_name, last_name)

        VALUES (NULL, 'Michael','Jackson'),(NULL, 'Taylor','Swift'),
		(NULL, 'Jiyong','Kwon'),(NULL, 'Bruno','Mars'),
		(NULL, 'Rick','James'),(NULL, 'Kanye','West'),
		(NULL, 'Justin','Timberlake'),(NULL, 'Iggy','Azelea'),
		(NULL, 'Pharell','Williams'),(NULL, 'Bob','Marley'),
		(NULL, 'Phil','Collins'),(NULL, 'Sam','Smith');
Angela Pham's avatar
Angela Pham committed



INSERT INTO record( title, artist_id, genre, year, price)

        VALUES  ('Thriller',1,'Pop',1983,4.95),
		('Bad Blood',2,'Pop',2014,3.99),
		('22',2,'Pop',2012,3.99),
		('One of a kind',3,'K-Pop',2012,3.99),
		('Treasure',4,'Pop',2012,4.99),
		('Give it to me baby',5,'Funk',1981,5.17),
		('Stronger',6,'Hip-Hop',2007,5.92),
		('Cry me a river',7,'RnB',2002,2.99),
		('Trouble',8,'Pop',2014,2.49),
		('Happy',9,'Pop',2014,3.26),
		('Three little birds',10,'Reggae',1977,3.99),
		('In the air tonight',11,'Rock',1981,2.10),
		('Stay with me',12,'Soul',2014,1.99)