Question: Given the following view that has been created, how would you query the playlist names and track names both in descending order? CREATE VIEW playlist
Given the following view that has been created, how would you query the playlist names and track names both in descending order?
CREATE VIEW playlisttracknames
AS
SELECT playlist.name as playlistname, track.name as trackname
FROM playlist
INNER JOIN playlisttrack
ON playlist.playlistid playlisttrack.playlistid
INNER JOIN track
ON playlisttrack.trackid track.trackid;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
