Lyric Music Database Relationships Microsoft Access-Relationships] File Edit Vie

Question

Lyric Music Database Relationships Microsoft Access-Relationships] File Edit View Relationships Iools Window Help Type a question for help - Tracks Studios Titles Tradkwum TrackTitle LengthSeconds MP3 RealAud StudioName Address City Region PostalCode Country WebAddress Contact EMail Phone SalesID ArtistID Title StudioID UPC Genre Genre Artists Genre ArtistID City Region WebAddress LeadSource Members SalesPeople MemberID FirstName LastName Address City Region PostalCode Country FirstName LastName Initials Base XrefArtist... MemberID RespParty WorkPhone EMail Birthday SalesID Ready

Explanation / Answer

Q11.

Select Studios.StudioID,Titles.Title,TrackTitle from Titles inner join Studios on Titles.StudioID = Studios.StudioID inner join Tracks on Tracks.TitleID = Titles.TitleID group by Studios.StudioID,Titles.Title having Studios.StudioID = 1;

Q12

Select Tiltles.Title,Studios.StudioID from Titles inner join Studios on Titles.StudioID = Studios.StudioID;

Q13

Select Salespeople.FirstName,Salespeople.LastName from SalesPeople inner join Members on SalesPeople.SalesID = Members.SalesID where Members.LastName = 'Alvarez';

Q14

Select Members.FirstName,Members.LastName ,Salespeople.FirstName,Salespeople.LastName from Members inner join Salespeople on SalesPeople.SalesID = Members.SalesID where Region = 'California';

Q15

Select ArtistName ,count(Titles.TitleID) from Artists inner join Titles on Artists.ArtistID = Titles.ArtistID group by ArtistName having count(Titles.TitleID) > 1;

Q16

Select Title from Titles , Count(TrackNum) from Titles inner join Tracks on Titles.TitleID = Tracks.TitleID group by Titles having Count(TrackNum) < 9;

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

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