My answers till now,(by the way I solved them but I am not sure if they are correct, so I wanted to get something like a model answer paper to compare and check.)
Answer.2) select name from Artist A where exists(select name from album B where A.name=B.name)
Answer.3)select A.name from Atist A, Track T, TrackList L where A.artistID=L.trackID and L.Tracknum=1 and T.name="Intro"
Answer.4)select artist.name from Artist where artist.name="Mogwai" and weight>(select weight from Artist,SimilarArtist where Artist.artistID=SimilarArtist.artistID)
Answer.5)select A.name from Album A,Tracklist L where L.tracknum>30 and L.albumID=A.albumID
M not getting the other answers. So if nething wrong in the above pls rectify.
The question has been closed Aug 10, 2010 at 09:49 AM by Kev Riley for the following reason:
Answer 3 is a cartesian join, so you'll want to look at that.
Other than that, are you sure you took the class? I'd strongly suggest you study the provided book a bit more.
answered Aug 10, 2010 at 08:47 AM
Grant Fritchey ♦♦