I have a diagram representing a database and need to find a way to update a given table with respect to information about elements in that table.
Here is the database design: https://i.stack.imgur.com/HR6q2.jpg
I have a Playlist defined which is called "Frank's Stuff" which is owned by the Customer Frank Harris.
The question is the following:
Update the playlist "Frank's Stuff" as a function of the track duration.
Display this playlist with the TrackID, Name and Milliseconds to verify.
I've read that you cannot use an ORDER BY statement with and UPDATE statement unless it is enclosed in a SELECT statement.
I'm not quite sure how to do all this though and would greatly appreciate some help.