Question

Saved Question 1 (20 points) List the names of responsible parties along with the artist name of the artist they are responsible for. select artists.artistname, mem Question 2 (20 points) List each artist name and a count of the number of members assigned to that artist AV Question 3 (20 points) List each title from the Title table along with the name of the studio where it was recorded, the name of the artist, and the number of tracks on the title. AV Question 4 (20 points) List the first and last names of all salespeople and the count of the number of members they work with. AV

Answer 1

Question 1:

Select Respparty, ArtistName from Xrefartistsmembers inner join Artists on Xrefartistsmembers. ArtistID = Artists.ArtistID;

Question 2:

Select ArtistName, Count(MemberID) from Xrefartistsmembers inner join Artists on Xrefartistsmembers. ArtistID = Artists.ArtistID;

Question 3:

Select title,StudioName, ArtistName, Count(Tracks.TrackID) from Titles inner join Artists on Titles.ArtistID = Artists.ArtistID inner join Studios on Studios.StudioID = Titles.StudioID inner join Tracks on Tracks.TrackID = Titles.TitleID;

Question 4:

Select FirstName,LastName, count(Members.MemberID) from SalesPeople, Members;

Question 5:

Select title,StudioName, Phone from Titles inner join Studios on Studios.StudioID = Titles.StudioID;

Do ask if any doubt. Please upvote.