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

Please Note: According to the Chegg Answering Guidelines, I have answered the first question and first 4 sub-parts, as the post contains more than 4 sub-parts. For receiving the answers to the rest of the Questions, please Re-post for the other Questions.

Answer)

Q11) List CD title and title of all tracks recorded in StudioID 1.

Answer)

select Titles.TitleID,

Tracks.TrackNum, Tracks.TrackTitle

from Titles inner join Tracks on

Titles.TitleID = Tracks.TitleID where Titles.StudioID=1;

Q12) List each title from Title table along with the name of the studio where recorded.

select Titles.TitleID,

Studios.StudioName from Titles

inner join Studios on Studios.StudioID = Titles.StudioID;

Q13) Find the name of the sales person who works with the member with last name 'Alvarez'

select SalesPeople.FirstName,

SalesPeople.LastName from

Members inner join SalesPeople on

Members.SalesID = SalesPeople.SalesID where Members.LastName = 'Alvarez';

Q14) List the name of the member from California(CA) and their salesperson.

select Members.FirstName,

Members.LastName, SalesPeople.FirstName, SalesPeople.LastName from Members inner join

SalesPeople on Members.SalesID = SalesPeople.SalesID where Members.region=

'California';

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

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