Question

Write a single SQL statement to create a new playlist called 'Background music'; and write another single SQL statement to associate the new playlist with the 10 longest duration tracks of jazz music from the Track table.

CREATE TABLE MediaType
(
MediaTypeID INTEGER PRIMARY KEY NOT NULL,
Name TEXT
);

CREATE TABLE Playlist
(
PlaylistID INTEGER PRIMARY KEY NOT NULL,
Name TEXT
);

CREATE TABLE PlaylistTrack
(
PlaylistID INTEGER NOT NULL,
TrackID INTEGER NOT NULL,
PRIMARY KEY (PlaylistID, TrackID),
FOREIGN KEY (PlaylistID) REFERENCES Playlist (PlaylistID)
       ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY (TrackID) REFERENCES Track (TrackID)
       ON DELETE NO ACTION ON UPDATE NO ACTION
);

CREATE TABLE Track
(
TrackID INTEGER PRIMARY KEY NOT NULL,
Name TEXT NOT NULL,
AlbumID INTEGER,
MediaTypeID INTEGER NOT NULL,
GenreID INTEGER,
Composer TEXT,
Millisecond INTEGER NOT NULL,
Byte INTEGER,
UnitPrice REAL NOT NULL,
FOREIGN KEY (AlbumID) REFERENCES Album (AlbumID)
       ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY (GenreID) REFERENCES Genre (GenreID)
       ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY (MediaTypeID) REFERENCES MediaType (MediaTypeID)
       ON DELETE NO ACTION ON UPDATE NO ACTION
);

CREATE TABLE Genre
(
GenreID INTEGER PRIMARY KEY NOT NULL,
Name TEXT

Answer 1

INSERT INTO playlist values (1,'Background Music')
-- here we are inserting values into playlsit table

INSERT INTO playlisttrack (PlaylistID,TrackID) SELECT playlist.PlaylistID,track.TrackID FROM playlist,track,genre where genre.Name = 'Jazz music' and genre.GenreID = track.GenreID order by track.Millisecond DESC limit 10

-- here we are taking select statement for inserting the values into playlisttrack
--Playlisttrack playlistID is selcted from playlist table and trackID is selected from track table
--in select statement we are sorting the tracks with Millisecond descending so that the top 10 are selected by limit 10

--below i have inserted manually for sample testing
--genre table values:

--trackid table values:

--executing the insert into query

--now the values are inserted into playlist track table

**************************************************************************
Please give an upvote,as it matters to me a lot :)

********************************************************************************