lab4.sql

2A.	Add the following playlist information to the database. 
The playlist, Songs to Play to Your Pugs, was created on November 15, 2017, and it has the following songs 
listed on it in this order:
i.	You Got Gold
ii.	Birds
iii.I Don’t Know Why
iv.	Everywhere I Go
*/
INSERT INTO PLAYLIST(playListName,playListCreatedOn)
VALUES ('Songs to Play to Your Pugs', 'November 15, 2017')

INSERT INTO SONG_PLAYLIST(playlistID,songID,song_playlistOrder)
VALUES	((SELECT playlistID FROM PLAYLIST WHERE playListName = 'Songs to Play to Your Pugs'),(SELECT songID FROM SONG WHERE songName = 'You Got Gold'),1),
		((SELECT playlistID FROM PLAYLIST WHERE playListName = 'Songs to Play to Your Pugs'),(SELECT songID FROM SONG WHERE songName = 'Birds'),2),
		((SELECT playlistID FROM PLAYLIST WHERE playListName = 'Songs to Play to Your Pugs'),(SELECT songID FROM SONG WHERE songName = 'I Don''t Know Why'),3),
		((SELECT playlistID FROM PLAYLIST WHERE playListName = 'Songs to Play to Your Pugs'),(SELECT songID FROM SONG WHERE songName = 'Everywhere I Go'),4)