Lyric Music Database Relationships Microsoft Access-Relationships] File Edit Vie
ID: 3756941 • Letter: L
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 ReadyExplanation / Answer
If you have any doubts, please give me comment...
-- 1)
SELECT MAX(LengthSeconds)
FROM Tracks
WHERE TitleID IN(
SELECT TitleID
FROM Titles
WHERE Genre = 'metal'
);
-- 2)
SELECT ArtistId, ArtistName, EntryDate
FROM Artists
WHERE EntryDate<ALL(
SELECT EntryDate
FROM Artists
WHERE LeadSource = 'directmail'
);
-- 3)
SELECT ArtistId, ArtistName, EntryDate
FROM Artists
WHERE EntryDate<ANY(
SELECT EntryDate
FROM Artists
WHERE LeadSource = 'directmail'
);
-- 4)
SELECT ArtistName, EntryDate
FROM Artists
WHERE EntryDate = (
SELECT MIN(EntryDate)
FROM Artists
);
-- 5)
SELECT TrackTitle
FROM Tracks
WHERE TitleID IN(
SELECT TitleID
FROM Titles
WHERE Genre = 'alternative'
);
-- 6)
SELECT Genre
FROM Genre
WHERE Genre NOT IN(
SELECT Genre
FROM Titles
);
-- 7)
SELECT TrackTitle, LengthSeconds
FROM Tracks
WHERE LengthSeconds = (
SELECT MAX(LengthSeconds)
FROM Tracks
WHERE TitleID IN(
SELECT TitleID
FROM Titles
WHERE Genre = 'metal'
)
);
-- 8)
SELECT TrackTitle, LengthSeconds
FROM Tracks
WHERE LengthSeconds = (
SELECT MAX(LengthSeconds)
FROM Tracks
);
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.