CREATE VIEW playlist$\_$track$\_$names

AS

SELECT playlist.name as playlist$\_$name, track.name as track$\_$name

FROM playlist

INNER JOIN playlist$\_$track

ON playlist.playlist$\_$id $=$ playlist$\_$track.playlist$\_$id

INNER JOIN track

ON playlist$\_$track.track$\_$id $=$ track.track$\_$id;

SELECT $*$

FROM playlist$\_$track$\_$names

ORDER BY track$\_$name, playlist$\_$name;

SELECT $*$

FROM playlist$\_$track$\_$names

ORDER BY playlist$\_$name ASC, track$\_$name ASC;

SELECT $*$

FROM playlist$\_$track$\_$names

ORDER BY playlist$\_$name, track$\_$name DESC;

SELECT $*$

FROM playlist$\_$track$\_$names

ORDER BY playlist$\_$name DESC, track$\_$name DESC;