Please help fast, I need to get the syntax for this: List all the tracktitles of

Question

Please help fast, I need to get the syntax for this:

List all the tracktitles of all tracks from the artist named "The Neurotics" in alphabetical order

I basically need the syntax that you would type into a command prompt, to access this information.

Here is a picture of the data base.

Please help fast, I need to get the syntax for this: List all the tracktitles of all tracks from the artist named "The Neurotics" in alphabetical order I basically need the syntax that you would type into a command prompt, to access this information.

Explanation / Answer

Both of below queries works for your requirement.

Select TrackTitle from Tracks where TitleID in (select TitleID from Titles where ArtistID in (select ArtistID from Artists where ArtistName='The Neurotics'))

(or)

Select TrackTitle from Tracks T, Titles Ti, Artists A where T.TitleID = Ti.TitleID and Ti.ArtistID = A.ArtistID and A.ArtistName=''The Neurotics'

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.